access equivalent to Text function

jscranton

Well-known Member
Joined
May 30, 2011
Messages
707
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,096,140
Messages
5,448,556
Members
405,518
Latest member
kaasplank

This Week's Hot Topics

Top