action (set value) in 2007 not available anymore

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

Guest

i need to set the current date on a field by click. in 97 i did that with a
macro which had the (set value) command in the action field. in 2007 there
is no such option.with 2007 how do i set the current date in a field by just
clicking into it?
 
2007 how do i set the current date in a field by just
clicking into it?
Click to expand...
I've not see v 2007, but in any normal version of Access you'd do it like
this:

private sub txtToday_Click()
if len(txtToday.Text)=0 then
txtToday.Text = Format(Now(),"yyyy-mm-dd""T""hh:nn:ss")
End If
end sub


Hope that helps


Tim F
 
Back
Top