Simple formatting question

[Kevin-anderson]

I have data stored in a column as text and its all different lengths. I need to format all enties to 5 digits. I know the answer is obvious, yet it alludes me. Any help would be appreciated.

Kevin

 

[SOS]

I have data stored in a column as text and its all different lengths. I need to format all enties to 5 digits. I know the answer is obvious, yet it alludes me. Any help would be appreciated.

Kevin

Do not apply formats at table level. Do it where you need it. Formatting at table level has been known to cause issues.

You can format in a query like:

MyNewName:Format([yourFieldName], "00000")

And form and report fields can be formatted in the controls that house them.

 

[Kevin-anderson]

Perfect Thank you!

 

[SOS]

Perfect Thank you!

No problem