Format Date Display in Access ADP

  • Thread starter Thread starter David C. Holley
  • Start date Start date
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.
 
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
 
Back
Top