Date showing #########

[stephaniechongg]

I have a text bot named txtDate and for my form timer event is the following code:

Private Sub Form_Timer()
Me.txtDigitalClock = Time
Me.txtDate = Date
End Sub

It works perfectly on my parallels as i am using a mac but when the form is transferred to another computer it shows ############# throughout

Any suggestions to change this?

 

[ypma]

Normally the #### would indicate that the field is too small to receive the date,try lengthing the date field .

Regards Ypma

 

[boerbende]

What I experienced is that the format on another computer is usually doing this. For example the date format is giving you a longer date or the font is different, and with that, the column you thought was wide enough, is suddenly too narrow

 

[arnelgp]

on form edit, put a Format on your date/time control of your choice, short date, long date, etc.