Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

INPUTTING THE DATE PROBLEM 1

Status
Not open for further replies.

chubby

Programmer
Apr 28, 2001
278
US
I was wondering, is there a way I can change the format for entering the date in my form to just yymm? My underlying table field is a date/time field.
 
Set format on textbox properties window yymm or write codes in procedure Form_Load

Private Sub Form_Load()
Me.txtTextBox.Format = "yymm"
End Sub

Aivars
LOL My summer holidays will start next week!
 
Thanks, I'll try it later on tonight. I have to work late.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top