Forums

This topic is locked

Format problem

Posted 26 Sep 2001 15:30:00
1
has voted
26 Sep 2001 15:30:00 Alex Xander posted:
anyone know why when i set the format of my field on the databinding window, its shows an error when the field is empty??
and what can i do to make a field what it sum all the other values displayed in a column field??
plz help me

Replies

Replied 27 Sep 2001 11:41:13
27 Sep 2001 11:41:13 Owen Eastwick replied:
Instead of leaving the field empty why not make it's default value zero if it's a numeric field. Your Sum and format properties should work OK then.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 27 Sep 2001 18:22:02
27 Sep 2001 18:22:02 Viktor Farcic replied:
You can also use if... then... statement. Something like:
<%
If NameOfTheRecordsetField <> "" Then
Display that field with formating
End If
%>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Instead of leaving the field empty why not make it's default value zero if it's a numeric field. Your Sum and format properties should work OK then.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Replied 27 Sep 2001 21:39:24
27 Sep 2001 21:39:24 Alex Xander replied:
Oeastwick im using 0 on the init value but the people sometimes try to erase it, do you know a vbs to store the value 0 if the field is empty??

im using this code but doesnt work
&lt;%
If Request.Form1("beneficio" = "" Then
document.Form1.beneficio.Value = 0
End If
%&gt;

please help me!!

Replied 27 Sep 2001 22:32:04
27 Sep 2001 22:32:04 Owen Eastwick replied:
Try this:

&lt;%
beneficio = Request.Form("beneficio"
If beneficio = "" Then
beneficio = 0
End If
%&gt;

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Reply to this topic