You could make the names on the report to be capital letters or proper so the "boss" would be more pleased with your job.
I know we could use < or > in the property sheet, but I dont know how to make it similar to the Proper function available in Excel.
IS there such a function in Access to accomplish that without VBA code?
Cheers!
Kevin Robertson
@Reply 4 years ago
If you don't want to use VBA you could do it in a Query
Expression: StrConv(String, 3)
In your report you could do it in the Control Source of the Text Box, but you would have to rename it so it wasn't the same name as any of the fields in the Recordset otherwise you would get an error.
= StrConv(String, 3)
In VBA you would write it like this
Expression = StrConv(String, vbProperCase)
Diogo CubaOP
@Reply 4 years ago
Thanks, Kevin!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 9.
