I have a combo box that is being populated by a Sql statement in the row source property. The Sql statement calls a VBA module to make a calculation on a date field to determine the quarter end. It works fine, EXCEPT, The dates are all left aligned in the combo box. This also means that in the SQL Builder in the criteria section when I put lets say a date in 09/30/2000. The SQL Builder doesn't recognize the fact that it's dealing with a date field. I've used CDate() and CVDATE() in my statements. What can You do to get it to recognize it is a date field thus eventually leading to a right alignment. The alignment is a symptom not the solution I'm trying to find.
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo Box ¦SQL¦VBA
- Thread starter pcdaveh
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question