Note that placeholders are displayed from right to left unless an exclamation mark character is present in the format expression. Consult Microsoft Visual Basic Reference for more information on the Format function and format expressions.

In the next code segment, I use the Format function to change a string literal to all upper case:

' Returns "HI THERE" Format("hi there", ">")

' Returns "access vba programming" Format("Access VBA Programming", "<")

0 0

Post a comment