Re: MS Access Date/Time, remove Time part from DataGrid ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Anatoly,

Thanks for the reply. However, my columns are dynmaically generated at
runtime so how can I know which column of the DataGrid to apply this Data
Formatting Expression setting to?

Perhaps you meant setting the Data Formatting Expression in the Access
column? - no such thing exists.

Any other ideas?

Thank you.
 
you can get a handle to the columns when they are being bound in the
itemdatabound event handler

e.item.cells[0] would be the first dynamically bound column (not necessarily
the first column).
 
Anatoly's got the right answer, regarding the format string, but for how to
apply it see the following Microsoft Knowledge Base article:

316672 HOW TO: Format Data and Handle Null Values in a DataGrid Web Control
http://support.microsoft.com/?id=316672

Keep in mind that format data stored for a column in a table in an Access
database is not accessible or used by our data access technologies. This
affects display within the Access application only.

Hope this helps!

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
 
Back
Top