Labels

[HServ]

I made a table that has all of the fields I want on my labels but when I
start the wizard, only 3 of the 5 are available to put on the label. How
does Access decide which fields will be included in a label when you use the
wizard, and how can I add the other 2 fields?
Thanks
Lis

 

[RuralGuy]

I made a table that has all of the fields I want on my labels but when I
start the wizard, only 3 of the 5 are available to put on the label. How
does Access decide which fields will be included in a label when you use
the wizard, and how can I add the other 2 fields?
Thanks
Lis

Hi Lis,

What names did you give the fields?

 

[HServ]

I named them "Contact", "Agency", "Address", "City" and Postal Code".
Only Contact, City and Postal Code show up in the wizard. Does the wizard
only recognize certain words as being an address? Thanks!

 

[RuralGuy]

I named them "Contact", "Agency", "Address", "City" and Postal Code".
Only Contact, City and Postal Code show up in the wizard. Does the wizard
only recognize certain words as being an address? Thanks!

Hi Lis,

Is that your only table so far? Are you using a table or a query? Try a
different table/query if you have one. The Wizard should show all of the
fields in the table/query.

hth

 

[HServ]

The problem turned out to be that a field with field type MEMO cant be put
onto a label. Once I changed the field type to TEXT all of the fields were
available in the Labels Wizard. You have to be careful though, any record
that is too long to be text will be deleted if you just change the field
type.

What I did was make a copy of the table and change field type in it. Then
when I tried to paste the records from the old table, the paste errors were
put into a table so I knew which ones I had to change.