Format Date Display in Access ADP

D

David C. Holley

Is there a way to force a combo box to display a date pulled from a SQL
Server database in a specific format? The date is being displayed as
YYYY-MM-DD which is the default for SQL Server. I seem to recall that combo
box's ignore the Format property.
 
D

David C. Holley

Actually, I solved my own problem. I figured out that I needed to add
another column to the call back function that loads up the combo box. The
new column has the date formated as YYYY-MM-DD which, given that its
ColumnWidth is set to 0 causes the correct date format to be displayed. The
second column, which is visible, displays the date as m/d/yyyy.

http://support.microsoft.com/kb/128197
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Select query with date range format issue 2
Strange Julian Date Phenomenon 9
Date format error 10
Set Default Date to European Format without changing Regional settingof the PC 6
format date with leading zeroes 3
Excel date format YYYYMMDD 1
Forcing a date entry format of dd/mm/yyyy 1
Combo box date format changes when item selected from list 4

Top