Full Version: Format unBound TextBox
UtterAccess Forums > Microsoft® Access > Access Forms
mike60smart
Hi Eveyone
I have the following unbound textbox which is displaying the last character of the Surnme control
=Right([Surname],1)
How would I format this to display the character in Uppercase
Regards
Mike
RAZMaddaz
In the Properties of the text box enter, click on the Format Tab and enter > in the format area.
Alan_G
Hi Mike
lternatively...........
=UCase(Right([Surname],1))
mike60smart
Hi Alan
Thanks - it is amazing how many simple things you forget
Mike
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.