By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,257 Members | 928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,257 IT Pros & Developers. It's quick & easy.

changing underlying Access text field to date/time problem

P: n/a
In my project I have an underlying Access DB. One of the column's is
currently set as a text field but I need to change it to a date/time
field.

I can open the Access DB in MS Access and change this in Design mode
and then set the format to 'Short Date' and then open the appropriate
table and it has converted all rows from:

1-5-95
5-13-95
etc...

to

1/5/1995
5/13/1995
etc...

And that's exactly what I want. But then when I run my project in
debug and it loads the datagridview with my DataView it populates the
column with not only the date, but also a default time. Thats not what
I want or desire. But since I set my datasource for the DGV like this

custDV = New DataView(MembershiptextDataSet1.Membership)
MembershipDataGridView.DataSource = custDV

I don't know of any way for me to set that column's format to show
only the short date that I need. Also, I have several other columns
that are also currently text fields that I'm thinking of changing to
date/time fields as well. But if I can't figure a way to stop it from
appending a time on I wont be able to do this.

Can someone help me get the result I'm trying for please?
---
Kyote
Aug 13 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.