NOW() DATE()

A

alex

I have Form that populates a Table.

On the Form, I have a Text Box with a default value of Date().

I want to change this default value to NOW() so that I can also see
the time in my table.

I don't want, however, users to see the time on the Form (only the
date). Is there a way to display Date() on the Form and populate
Now() into the table.

I realize that I could create two controls and then hide one on the
Form; I'd like, however, to do this in the same Text Box.

Any suggestions?

alex
 
J

Joan Wild

Set the default value of the textbox to Now() and then set the format to
Short Date.
 
R

Rick Brandt

alex said:
I have Form that populates a Table.

On the Form, I have a Text Box with a default value of Date().

I want to change this default value to NOW() so that I can also see
the time in my table.

I don't want, however, users to see the time on the Form (only the
date). Is there a way to display Date() on the Form and populate
Now() into the table.

I realize that I could create two controls and then hide one on the
Form; I'd like, however, to do this in the same Text Box.

Any suggestions?
Click to expand...

If you apply a format to the TextBox that does not include the time then
they will not see it unless they place the cursor in the control. If you
don't want the user to change the value from the default then set Enabled =
No and Locked = Yes so thay can't put the cursor in the control.
 
A

alex

Set the default value of the textbox to Now() and then set the format to
Short Date.

--
Joan Wild











- Show quoted text -
Click to expand...

That did it Joan...I feel silly (didn't think it was that easy), but
thanks.

alex
 
I

i_takeuti

alex said:
I have Form that populates a Table.

On the Form, I have a Text Box with a default value of Date().

I want to change this default value to NOW() so that I can also see
the time in my table.

I don't want, however, users to see the time on the Form (only the
date). Is there a way to display Date() on the Form and populate
Now() into the table.

I realize that I could create two controls and then hide one on the
Form; I'd like, however, to do this in the same Text Box.

Any suggestions?

alex
Click to expand...
 
Top