I have two problems. The first is quite simple, the second I suspect is not.

1. I have a forecasting database which uses an inflation factor chosen from a combobox. The box itself displays the percentage correctly as 3.1% (for example), but when the list is dropped, the figures appear as 0.029, 0.03, 0.031 etc. Is there any way to format the figures in the dropped list, as not all users may realise the formatting problems. Would a small formatted table as the RowSource help?

2. We have another database (Access 2000 format but developed in Access 2003 - it's a long story!) which we have just ported across to a SQL 7 box. I am now getting and error message 'Error 3622 Open SQL Server Table with Identity Column'. Knowledge Base article 090620 tells me that every OpenRecordset command on a table with an IDENTITY column (that's the result of an ID, AutoNumber field in Access) must now be rewritten as OpenRecordset("table name", dbSeeChanges). As you can imagine, there are hundreds of these things. I had thought about dropping the AutoNumber fields, but then the Upsized table will not be updateable in SQL because it must have a Primary Key (or whatever SQL calls it). Does anyone have any suggestions of an easier way around this? Does anyone know if this will happen when we move over to SQL 2000 in a week or so?

Thanks