Blank Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to replace a table's field named "date" with a blank/null using a
cmdbutton. I read the VBA help but always seem to find something I was
looking for a month ago. This has to be simple, can someone offer help??

Thanks in Advance
 
First, "date" is a reserved word and should not be used to name objects in
your database.

You want to rename a filed in your database to blank? I'm pretty sure that
would not be a valid field name.
 
Rick, Hi. No I have a date in the field but I want to remove that date so
the field is blank but I don't know how to do it I've put in TheDate = "# #"
and other variations with no results
 
YourDateField = Null

williamr said:
Rick, Hi. No I have a date in the field but I want to remove that date so
the field is blank but I don't know how to do it I've put in TheDate = "#
#"
and other variations with no results
Click to expand...
 
Back
Top