show text box value

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

Guest

I have 2 text boxes one for street address and one for PO Box address. I have
a report that prints labels of people's addresses and I want to be able to
print the records if the PO Box exists then it won't show the street address,
and if it doesn't exist then it shows the street address. What I want to
avoid is having both addresses on one label.
Tx
 
=NZ([FirstField], [SecondField])

The NZ function will return the first argument (FirstField in this example)
unless the first argument is Null, in which case it will return the second
argument (SecondField in this example).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
TX Brendan,
but it gives me an "#error#" if the first field doesn't exist??
Del

Brendan Reynolds said:
=NZ([FirstField], [SecondField])

The NZ function will return the first argument (FirstField in this example)
unless the first argument is Null, in which case it will return the second
argument (SecondField in this example).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


Del said:
I have 2 text boxes one for street address and one for PO Box address. I
have
a report that prints labels of people's addresses and I want to be able to
print the records if the PO Box exists then it won't show the street
address,
and if it doesn't exist then it shows the street address. What I want to
avoid is having both addresses on one label.
Tx
Click to expand...
Click to expand...
 
Sorry Brendan, I fixed it
Tx heaps that was super helpful. I love this community group, you guys are
cool.......
Best wishes for 2005!
Del

Brendan Reynolds said:
=NZ([FirstField], [SecondField])

The NZ function will return the first argument (FirstField in this example)
unless the first argument is Null, in which case it will return the second
argument (SecondField in this example).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


Del said:
I have 2 text boxes one for street address and one for PO Box address. I
have
a report that prints labels of people's addresses and I want to be able to
print the records if the PO Box exists then it won't show the street
address,
and if it doesn't exist then it shows the street address. What I want to
avoid is having both addresses on one label.
Tx
Click to expand...
Click to expand...
 
Back
Top