help with report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a business card report that shows name, cell phone, email,
title, address, and fax. so far i have everything working fine, as long as
the person who i am printing the cards for as a cell phone. some of the
people don't and for those people i don't want to show the label portion of
the text box with the word "Cell:" in it and then not have a cell number to
go after it. what would be easiest or best way of accomplishing this?
thanks in advance for any ideas.
 
I would add an unbound text box and set it to CAN SHRINK. I'd put the
following....

="Cell: " + [CellPhone]
 
The easiest method is to change the "Cell:" label to a text box and set it's
control source to:
="Cell: " + [CellPhoneField]
Make sure the text box displays only the "Cell: " and don't allow it to
grow.
 
ok, this works, thanks


Rick B said:
I would add an unbound text box and set it to CAN SHRINK. I'd put the
following....

="Cell: " + [CellPhone]




--
Rick B



jkendrick75 said:
I am creating a business card report that shows name, cell phone, email,
title, address, and fax. so far i have everything working fine, as long as
the person who i am printing the cards for as a cell phone. some of the
people don't and for those people i don't want to show the label portion of
the text box with the word "Cell:" in it and then not have a cell number to
go after it. what would be easiest or best way of accomplishing this?
thanks in advance for any ideas.
Click to expand...
Click to expand...
 
Back
Top