please help - problem with empty fiekds in a form - FP 2002

[samuel]

I have a form where some of the fields are both optional
and have no assigned values (they are empty).

When I list the results, with a confirmation page, I get
an error for those fields that were optional and not
filled out and the error tells me that it cannot read
zero sring values.

I would need to assign a value to these optional empty
fields but if I do that that value is going to show on
each field both when the user is entering values and when
these fileds are listed on the results page.

Is there any way to assign values to the fields so I do
not get this error and do not see preassigned values that
would be empty otherwise?

Thanks for your help

 

[Kevin Spencer]

What kind of form handler are you using?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Neither a follower nor a lender be.

 

[Thomas A. Rowe]

If using Access, you can open the database in Access and set the field
attributes to allow Null values.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Thomas A. Rowe]

For #1 or #2 you must open the database directly in Access, then select the
table, then click Design, then select each field that you want to change the
attributes on, etc.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================