Mailing Labels

[Nigel M]

I thought I'd have a go at using Access to print some mailing labels,
rather than involving Word. The Label Wizard started off well, but then
I found that the field I wanted didn't appear in the list. I know the
field is in the query - this is the same one I've been using in Word.

The missing field is a "Memo", is this the problem? Is there a solution?

Also, in case I'm wasting my time, can the font sizes and colours of
individual fields be altered at a later stage?

 

[Rob Oldfield]

You're correct. Memo fields don't show up when you use the label wizard.
You can though just add it to the design of the label once the wizard is
finished. And yes, you can change font sizes etc later on.

 

[Nigel M]

Memo fields don't show up when you use the label wizard.
You can though just add it to the design of the label...

Thanks, sorted now. I thought I was going mad!

And yes, you can change font sizes etc later on.

I found I had to add fields on separate lines, then move them, but I'm
nearly there. One thing I forgot (and I bet this is a problem) I need
for one of the fields (the memo) to be printed in CAPS.

Can this be done? If not, can the field be forced to all caps?

 

[Rob Oldfield]

Change the control source of that control to =ucase(<whatever it said to
start with>)

 

[Nigel M]

Change the control source of that control to =ucase(<whatever it said to
start with>)

Wow!