Pad function

J

Joe Cilinceon

Is there a Pad function in Access? The Pad function will pad a string with
say spaces for example "AA" could be split in "A A" with a pad function
by adding 4 spaces.
 
D

David Seeto via AccessMonster.com

No, there isn't any such function, but you could write one yourself using
the String functions that Access DOES provide: the key ones are LEN (tells
you the length of the string) and MID (takes a chunk out of an existing
string). Have a look at the Help on these and post again if you need more
help building the right expression.
 
J

Joe Cilinceon

Thanks for your response and I did find one in VB called Spaces(). It was
exactly what I needed.
 
Top