Getting a form field to display info when selected.

[Othy]

The Issue
I have a form that's working for 99% of what I need it to do; but I'm having one problem. The form is set up to track time spent; so naturally it has a start time and a time finished. The start time is set with a default value of Time() (access 2007). This part is working great.

Originally, I had the finished time set the same way; but was constantly having to change the value (which kind of defeats the purpose of having it show up on its own). What I am looking to do is have the time finished field automatically display when I click in that box as though I were going to type the field.

Solutions I've Tried
I've tried going into the properties of the field inside the form and adding the expression "=Time()" to the "On Click" field but nothing happens when I click in the field after doing this. I've tried doing the same thing in a few other property fields and it still isn't working. I've also looked at the property sheet for the table on which the form is based, but I don't see anywhere in the table to do this.

I have removed the default value from the time finished field so I know that is not what's causing the problem.

All help is appreciated!

[pbaldy]

Try

Me.TextboxName = Time()

That would be VBA code that goes here:

http://www.baldyweb.com/FirstVBA.htm

[Othy]

You are my hero!

[pbaldy]

Happy to help, and welcome to the site!