Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

VbProperCase in Reports

Resolved · Low Priority · Version 2003

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Access articles

· So what's new in Access 2007?
· How To Change The Data Displayed In A Linked Field In An Access Table
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Express Yourself With Microsoft Access
· How To Create An Index Report In Access

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

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.

View all Access hints and tips