VBA Date & Time problem

[GaleT]

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

 

[theDBguy]

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.

 

[GaleT]

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

 

[theDBguy]

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

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