NOW() DATE()

[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

 

[Joan Wild]

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

 

[Rick Brandt]

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?

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.

 

[alex]

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

--
Joan Wild











- Show quoted text -

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

alex

 

[i_takeuti]

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