numbers in queries (1 Viewer)

[disgruntled]

Hello all.....i have a form which is used to make an entry in a table with many fields. I do not want the fields to be mandatory. All the text fields are np as i set the allowzerolength property. Numbers however dont have this property and will crash the query when not entered. Anybody know how to make them alloud to be left blank (the required property is set to no). Thanks a bunch
Grant

 

[Pat Hartman]

Please don't post the same question in multiple topics. Your question was already answered.

 

[disgruntled]

i apologize about that. I honestly forgot i even posted that yesterday! However, the suggestion is not working for me. it is used in a SQL INSERT statement coming from a form. I have tried both of these but it still doesn't like

......., nz(" & tbox_SLOPE & "), ......
and
......., " & nz(tbox_SLOPE) & ", ......

the examples in the help do not use the function in this manner.

 

[disgruntled]

Got it........the alternative seems to be a must.....
ie. " & Nz(tbox_SLOPE, 0) & "

The help was appreciated
G