Simple formatting issue, but how?

[RexesOperator]

Access 2003 user. On my report is the string

8959-19 (DAAD/wd)

I am using

DAADFILENUM: " 8959-19 (DAAD/" & [CompletedBy] & ")"

Which works, but how can I make [CompletedBy] lower case? I tried < in the format of the text box, but the whole textbox becomes lower case, not just the initials.

Darn it - I just solved this myself:

" 8959-19 (DAAD/" & LCase([CompletedBy]) & ")"

if anyone needs something similar - search and help really do work!

 

[ajetrumpet]

search and help really do work!

YOU'RE KIDDING!? WOW! There IS a help menu afterall!!!!

 

[RexesOperator]

YOU'RE KIDDING!? WOW! There IS a help menu afterall!!!!

The surprise is not the help menu - but that it is actually useful! Normally help-menus associated with Microsoft products are something of an oxy-moron!

 

[ajetrumpet]

Normally help-menus associated with Microsoft products are something of an oxy-moron!

No "Oxy" necessary to be concatenated there.