Clare has attended:
Access Advanced course
Access VBA course
VbProperCase in Reports
Hi,
I want to display name and adress data in a report in vbProperCase which is stored in a table as Upper Case.
I have tried using ?>????????????? as an input mask which leaves the first letter of the first word in upper case and converts the rest into lower case. The problem is I need each word to be capitalized.
I have also tried StrConv but this doesn't seem to work in report..
I only want to display the data in the report in proper case. I want to leave the data in the table in upper case.
Please help! :-)
Clare
RE: vbProperCase in Reports
Dear Clare
Thank you for attending Access Courses.
From our records I can see that you have attended our Access VBA course and I hope that you are comfortable in writing the codes.
I would suggest you to create a query based on the original table and then create a Report based on the Query rather than the Table before you carry out the steps in the below mentioned link:
http://support.microsoft.com/kb/815282
Please let me know if it worked. You'll see the link uses a sample table and fields that you can quickly create and then customize them to your database that you have!!
!! I hope you enjoyed the course and benefited from it.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
