access equivalent to Text function

[jscranton]

I have a db filed with numbers stored as strings. I need to convert them to 9 characters but some had their leading zeroes trimmed off at some point.

So, 012345678 became 12345678.

I would normally do Text(stringHere,"000000000") to convert this in Excel.

Is there an equivalent function in Access?

Thanks,

Justin

 

[jscranton]

Nevermind. It is just Format(string, format) like in VBA.

 

[Joe4]

Take a look at the FORMAT function.
See: https://www.w3schools.com/sql/func_msaccess_format.asp

The structure is identical to the Excel Text function.