By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Insert a Dash in a reprot

P: n/a
How can I insert a -(dash) in a report if there is no value in the field?
Thanks,
Greg
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Set the control source of the textbox to

=Nz([FieldName], "-")

If the value of the field is Null then it will be replace with the -.

--
Wayne Morgan
"Greg" <gk******@itlan.net> wrote in message
news:XD*****************@nwrdny01.gnilink.net...
How can I insert a -(dash) in a report if there is no value in the field?

Nov 12 '05 #2

P: n/a
I get #Error as my ruslts.
Greg

"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:SI*****************@newssvr17.news.prodigy.co m...
Set the control source of the textbox to

=Nz([FieldName], "-")

If the value of the field is Null then it will be replace with the -.

--
Wayne Morgan
"Greg" <gk******@itlan.net> wrote in message
news:XD*****************@nwrdny01.gnilink.net...
How can I insert a -(dash) in a report if there is no value in the
field?

Nov 12 '05 #3

P: n/a
Make sure the name of the control is not the same as whatever the field name
in the expression is.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Greg" <gk******@itlan.net> wrote in message
news:h5*******************@nwrdny01.gnilink.net...
I get #Error as my ruslts.
Greg

"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:SI*****************@newssvr17.news.prodigy.co m...
Set the control source of the textbox to

=Nz([FieldName], "-")

If the value of the field is Null then it will be replace with the -.

--
Wayne Morgan
"Greg" <gk******@itlan.net> wrote in message
news:XD*****************@nwrdny01.gnilink.net...
How can I insert a -(dash) in a report if there is no value in the

field?


Nov 12 '05 #4

P: n/a
Got it I did not know I needed to do this in an unbound textbox!!!

Thanks for the help!

Greg

"Greg" <gk******@itlan.net> wrote in message
news:XD*****************@nwrdny01.gnilink.net...
How can I insert a -(dash) in a report if there is no value in the field?
Thanks,
Greg

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.