Pad function

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
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.
 
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.
 
Thanks for your response and I did find one in VB called Spaces(). It was
exactly what I needed.
 
Back
Top