Blank Date

W

williamr

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
 
R

Rick B

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.
 
W

williamr

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
 
P

Pat Hartman\(MVP\)

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...
 
Top