Access date stamp

[brumy]

I would like to include an option in an Access form that would allow the current date to be entered in a field box by just checking a box beside it -- doable?

Darren

 

[evilla]

in the click event of the box you want to just check put something like txtBoxIwantTheDate2ShowUpIn = Now

 

[brumy]

I tried the "=now", but that did not seem to work -- the text box I am wanting to have updated is linked to a field in the master table with a date format -- should I xcahnge the format?

I typed exactly this in the "on click" event -- "=now(dd,mm,yy)"

Am I missing something?

Darren

 

[evilla]

this works for me

Private Sub Command2_Click()
Text0 = Now() ' gives date and time

Text0 = Date ' gives just the date
End Sub

what sort of error are you getting?

 

[Rolliee]

I use a double click on the date type textboxes. If the TB is null, it puts today's date in it. If not it either advances the date by one or decreases the date by one day - whichever makes sense in your app.

private sub text0_dblClick()

if IsNull( me.text0) then
me.text0 = int(now())
else
me.text0 = me.text0 +1
endif

end sub


Rollie E