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 » Access using < or > in the format field in design view to defaul
Access using < or > in the format field in design view to defaul
Resolved · Medium Priority · Version 2007
Mon 31 Oct 2011, 13:21Delegate 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:57Trainer 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:09Delegate 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:54Trainer 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 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:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |
