VBA Date & Time problem (1 Viewer)

Hi,
I need to enter the current Date/Time in a form field Txt_BARTinvoiceSub

This form is used to update existing records.

The recipient Table Field to be updated after I get the correct value in the form is formatted as Date/Time.


The following results in pound signs ######## entered into the form field.
Dim dtInvRequestSent As Date
dtInvRequestSent = Now()
Me.Txt_BARTinvoiceSub.Value = dtInvRequestSent



Help!



Gale

Hi Gale. Maybe the Textbox on the form is not wide enough to display the date and time returned by the Now() function. Try widening it to see if that helps.

That was it... thank you so much!
Gale

GaleT said:

That was it... thank you so much!
Gale

Click to expand...

Hi Gale. You're welcome. Glad to hear you got it working. Good luck with your project.