Re: RE: [MS_AccessPros] How do I format a Dat e/Time field to display the actual time…

 

Thank you Tony

I assigned the NoteDt as you can see from the code below. Doesn't it already have the time in the Format function?

How do I add the time to it in this case?

With rs
    .AddNew
     !Sid = Me.txtSID
     !NoteDt = Format(Me.txtNoteDt, "mm/dd/yyyy hh:nn AM/PM"))
     !Note = Me.txtNote
    .Update
    .Close
End With

Thank again and Happy holiday

Phucon

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___