By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,519 Members | 2,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,519 IT Pros & Developers. It's quick & easy.

Syntax Error For Null Date Field

P: 32
Good afternoon,

I am currently working on this unbounded form that has numerous date fields. I wanted to know if it is possible to save data in a form, with a null date field. I am currently getting an error, and would like to know if there is a way around it. I am doing this feature just in case users do not need to enter a date for a specific record.

Also, when the form is loaded all the controls (checkbox, combobox, listbox, and textbox) are set to Null.

An urgent response is needed!!!

Oct 11 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,653
Hi, klove1209.

So if I got it right you need controls to be populated with default values in the unbound form.

I think you have two options.
  • Store default values in Control.Tag property and set Control.Value to Control.Tag on form load.
  • Bind the form to a table with one record containing default field values and take measures to prevent saving to the table (i.e. remove navigation buttons, call Form.Undo in Form_BeforeUpdate event handler.
Oct 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.