473,503 Members | 10,245 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Insert a Dash in a reprot

How can I insert a -(dash) in a report if there is no value in the field?
Thanks,
Greg
Nov 12 '05 #1
4 2571
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3331
by: Krista | last post by:
Hi guys, i have a problem about inserting data into the table. I dont know why the output always said cannot be added to the database! Anyone has idea for me? i check the connect is ok, but dont...
2
2418
by: Venus | last post by:
Hi all, Newbie here!! I have 4 forms(A,B,C,D) and a thank you page for my questionnaire. People will be redirected to B or C depending on the last question's answer. B or C will redirect to D...
4
1800
by: Caversham | last post by:
I am trying to insert data into the fields id and term of the table key. id is an auto-incrementing field. Each of the following forms fails:- INSERT INTO key (id, term) VALUES (0, 'dog') ...
1
7259
by: Sue | last post by:
Hello I'm new to this Regular Expression and need some help. I want to restrict what the user types in a text box. The User can type only A-Z, a-z, 0-9, spaces, comma, dash, period, single...
1
1461
by: mats.broberg | last post by:
Dear all, I'm having a scientific text translated into the majority of western and eastern European languages* and have provided a small leaflet with typesetting rules for the translators. Some...
1
8922
by: Jennifer | last post by:
I'm trying to do an insert using Bulk Insert with a fixed length file. I'm using a format file. I'm getting the following error message: Cannot perform bulk insert. Invalid collation name for...
3
3910
by: Sebastian M. Rouaiha | last post by:
Hi. I have a problem. When drawing into a graphics context I sometimes get access violation exceptions and I can't figure out why. It seems to have to do with the use of custom dashes. If I...
7
5289
by: FNA access | last post by:
I have a form that demands an input mask for a text box. The text box has a mask of three numbers then a space a dash another space and three more numbers. This mask repeats itself upto a max of 4...
0
2310
by: =?ISO-8859-1?Q?=22Martin_v=2E_L=F6wis=22?= | last post by:
"C:\Python24\Lib\site-packages\MySQLdb\cursors.py", line 149, in Here it complains that it deals with the character U+2013, which is "EN DASH"; it complains that the encoding called "latin-1"...
0
7316
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7449
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5562
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4666
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3160
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3148
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1495
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
728
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
371
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.