Access using < or > in the format field in design view to defaul

Resolved · Medium Priority · Version 2007

Mon 31 Oct 2011, 13:21 Delegate Kelly said...

Kelly has attended:
Access Introduction course

Access using < or > in the format field in design view to defaul

I learnt this on the begginers Access course and its very handy to use on my data bases for post codes so they always appear in Capitals. however, when I run a query and then a report to print off some labels, the post code appears in the format it was entered in. So if I look at my table all my post codes are in capitals, but on my labels all my post codes print out in lower case! How do I fix this so what appears in the table, appears on my lables?

Tue 1 Nov 2011, 16:57 Trainer Doug said...

RE: Access using < or > in the format field in design view to de

Hi Kelly

Glad you found a good use for the upper case format > in Access. Unfortunately when you mailmerge the data into Word the formats get removed.

But you can add format codes to fields in Word as well!
In your labels document before you merge it,
Right click on a field
Choose Toggle Field Codes
Type \* Upper
Right click and Toggle Field Codes again.

For example {MERGEFIELD "Complany" \* Upper}
will make each company print in upper case.

If you look in Help these are called field code switches.
They can be used to format dates or numbers as well as text.

\@ dd MMMM yyyy
\# £#,##0.00

Regards
Doug Dunn
Best STL

Tue 1 Nov 2011, 17:09 Delegate Kelly said...

RE: Access using < or > in the format field in design view to de

Dear Doug,

I'm sorry but I don't understand why you mention Word? I make the labels in Access by running a query and then a report. At no time do I use word? I don't do a mailmerge when I make labels, everything is done in Access with Label Wizard.

PLease can you explain,

many thanks

Kelly

Wed 30 Nov 2011, 16:54 Trainer Doug said...

RE: Access using < or > in the format field in design view to de

Hi Kelly

Fo labels created from Access (not Word!) the format codes eg > have to be added again.

Can be done by going into Design mode for your labels report.

Then select all the fields that are to be set for upper case.

Click Properties and select the Formart property entering > for upper case.

Hope that helps and sorry for the confusion about Word.

Regards

Doug

Doug Dunn
BEST STL

Tue 6 Dec 2011: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips