Missing Preceding Zeros

[firestorm52]

I need to change the formatting for a certain field in one of my tables without having to re-enter all 600+ records. Somehow the data type for this certain field was changed from Text to Number. The original data had a 6 digit input mask so there were multiple entries that had preceding zeros in them. When I changed the data type back to what it should be (Text), the preceding zeros were dropped. Needless to say, the software no longer brings up all the information it used to since some of the info in related tables requires the preceding zeros. Can anyone point me in the right direction to finding these missing zeros or am I stuck having to re-enter the data?

 

[Mile-O]

Run an update query to change the field back like this - just change the names to suit, and run the query.

UPDATE MyTable SET MyField = Format([MyField], "000000");

 

[firestorm52]

Much Appreciated

Thanks Mile-O-Phile for your help. I really appreciate it.