Text Formatting

[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

 

[Allen Browne]

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.