Label issues

[Sully38]

I have spent the better part of this AM killing half the rain forrest..Please help.. I am trying to create a label based report which consistently is printing correctly, but then "Prints" a blank sticker.
I believe my problem is that when my query which formats multiple fields into one field it is creating a 255 char field and causing the "overflow" I am using this in my query:
FullName: Format(Trim([firstname] & " " & [Lastname]))
any comments or help is appreciated by both me and the rain forrest..

 

[Dugantrain]

I believe that your problem is that you're using the Format function which has two arguments: What you'd like formatted and the way that you want it formatted. Example:

Format([DateField],"Short Date")

Since your second argument is empty, you should be getting at best a Null value and at worst a RunTime error. Try taking it out and just use

Trim([firstname] & " " & [Lastname])

and see if that works out.

 

[Sully38]

I still end up with a 255 byte field. I dont uderstand it either. I'm combining FName which is 10 chars. and LName which is 15 chars..

 

[Dugantrain]

Maybe you should use the Trim function on each field and Then pull them together?

FullName:  Trim([FirstName]) & " " & Trim([LastName])

 

[Sully38]

Problem Solved... It was a faulty driver from the printer manufacturer. I downloaded a new & Improved driver and then it worked like a Champ!!! My brain is safe and the forrest is making a comeback..Thank You for your help, now its time for that lunch I missed...