Label Wizard

[beckettlaura]

I have a query with 5 fields. I'm trying to use all 5 fields in a label. Using the label wizard, I get as far as picking the font size, and when I want to select the fields to go where on the label, ONE field doesn't show up in the fields available!!! It's called "description"...does anyone have any idea why it doesn't show up????

 

[boblarson]

If you open up the query, are you sure that all 5 fields have the selected checkbox clicked?

 

[beckettlaura]

Yes, if you mean in design view of the query, it is checked off.

 

[beckettlaura]

hey - figured it out!! Thanks for your help...it triggered my thots to check how it was set in the table and it was under "memo" not "text" so I changed that and it showed up. Thanks soo much again!~!

 

[boblarson]

hey - figured it out!! Thanks for your help...it triggered my thots to check how it was set in the table and it was under "memo" not "text" so I changed that and it showed up. Thanks soo much again!~!

Glad you got it sorted and that you posted back with your results!