Initial value help

P

Paul M

Hi
I have a text box in a form which posts to an update.asp. if the person
using the form leaves the text box empty I get a database error. I have got
over this by having a initial value char of "-" which doesn't look to bad.
But it would look better without anything especially because the "-" gets
added to the database
Thanks
Paul M
 
P

p c

Opn your database in Acces, open the table, switch to design mode, and
go properties for the field. For Required selrct NO, for Allow Zero
length select Yes. Save and you are good to go.

...PC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check box help 2
Initial value of text box properties 2
Cursor Location in a form text box 15
Security help please 7
Database editor help please 4
initial values of FP form fields 8
Setting initial focus in form 1
Choose a value from a combo box based on a text box 0

Top