Field Type Conversion

I

islandlover

I have developed a form with information going to an Access Database. For
some reason the credit card numbers are appearing similar to the following:
4.4909233454533E+12. I have tried going to my table and changing the field
type from General Number to Text but Access deletes the records instead of
converting. What do I need to do to correct this? Also, what made this
happen? Thanks for your help!!
 
J

Jeanette Cunningham

You are right to want to change it to a text field. 4.4909233454533E+12 is
the way Access writes numbers with many decimal places.
Add a new field to your table for the text field for the credit card
numbers.
Create a query using your table and drag the new text field just created on
to the query grid.
Change it to an update query using Query >> Update query.
In the Update To: row type TheTableName.TheCreditCardFieldName
Replace TheTableName with your table name and TheCreditCardFieldName with
the name of the number field with the credit card numbers on it.
Run the update query.
Open the table and check that the numbers are correctly in the new field.
If all OK, make a copy of your table. Name one copy to keep as backup. On
the other copy you can delete the number field that not's needed any more
and rename the new text field to the name you had for the number field. Now
any queries based on that table should work.

Jeanette Cunningham
 
Top