Text Formatting

  • Thread starter Thread starter JeffMo
  • Start date Start date
J

JeffMo

I am trying to put the output for a report in Proper text
(Upper Case 1st letter and Lower Case for the remainder of
the letters)This seems very simple but I cannot figure out
how to do it...Help Please...Thanks
 
Set the Control Source of your text box to:
=StrConv([YourFieldNameHere], 3)

Then change the Name property of the text box: you confuse Access if the
control has the same Name as a field, but is bound to an expression.
 
Back
Top