Date into TextBox

2 Advanced

Registered User.
Local time
Today, 14:12
Joined
Mar 2, 2006
Messages
21
Hi, im able to produce the following 3 combo boxes, Day, Month and Year. By selecting a date using the 3 combo boxes onto the Form. I want to able to insert the date into the textbox.

Any ideas how i might able to get it working on the forms?

Many Thanks
 
just go something like this ... txtDate = Me.cboYear & "-" & Me.cboMonth & "-" & Me.cboDay... this assumes you have a number in the month box... if not .. . populate the combo box with 2 column IE 1 | Jan, 2 | Feb, etc then instead of Me.cboMonth make it Me.cboMonth.column(0)
 
Hi Ethereal, thanks for your reply. I tried inserting the sample code you have given me and put it into a text box in the form design under: Control Source.

I made some adjustment to match mine:

[txtDate]=Me.ComboDay & "-" & Me.ComboMonth & "-" & Me.ComboYear

but it doesn't seem to work..

Perhaps any1 else maybe help me out with this problem?

Thank you!
 
Last edited:
I implemented what i said should work, It did :P Check it out and see what you're missing .. My instructions weren't 100% codeworthy, but this example demonstrates what i wanted to say... I also added a calander feature you may be interested in using and put a big button with a pic of a calander on the form named Table1... OK try it out... Let me know
 

Attachments

:D I see where i have gone wrong with this problem. Your example works perfectly.

Thank you very much, Much appreciated :):)
 
Glad I could help, These forums have been a lifesaver for me... Thought i'd pass it on
 

Users who are viewing this thread

Back
Top Bottom