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

VbProperCase in Reports

ResolvedVersion 2003

Wed 11 Feb 2009, 12:20 Delegate 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

Fri 13 Feb 2009, 14:32 Trainer Rajeev said...

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 tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

VbProperCase in Reports

VbProperCase in Reports

RE: vbProperCase in Reports

Access articles

Access tip:

Choosing data types in Access