98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » VbProperCase in Reports
VbProperCase in Reports
Resolved · Low Priority · Version 2003
Wed 11 Feb 2009, 12:21Delegate Clare said...
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
Thu 12 Feb 2009, 15:45Trainer Rajeev said...
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
Thu 19 Feb 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:How To Display An '&' In A Label In A FormTo have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as: |
