Greetings,
Currently in office 365 ms access, I have two fields CustID & LOC formatted as number data types in access table. As a result, the leading zeros are not displayed in the access form. CustID is a seven digit # and LOC is a 2 digit #.
I'm familiar with changing the data type as text and/or formatting as "0000000" and "00". But, this changes existing entries. I was wondering if there is a way not to retro update, but apply the changes moving forward.
TIA
Regards,
Currently in office 365 ms access, I have two fields CustID & LOC formatted as number data types in access table. As a result, the leading zeros are not displayed in the access form. CustID is a seven digit # and LOC is a 2 digit #.
I'm familiar with changing the data type as text and/or formatting as "0000000" and "00". But, this changes existing entries. I was wondering if there is a way not to retro update, but apply the changes moving forward.
TIA
Regards,