vbpropercase reports
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VbProperCase in Reports

VbProperCase in Reports

resolvedResolved · Low Priority · Version 2003

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

I believe that you have posted the same question twice. Thank you for your post I have replied to your other post which has the same query and please let me know if it was of any use or not.



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

Fri 20 Feb 2009: Automatically marked as resolved.


 

Access articles

Please browse our web site to find out more about
access courses in london and other training courses.

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.07 secs.