davecocks
asked on
Making datetime field return just time
HI,
I've got a table stored as an .mdf in visual Studio
The field is set to datetime
I'm inputting values from a combo box (selecting time in 15 bunches)
But when it adds the time to the record the date is still displayed in the field
What do I need to change to make it just display the time in the records with no date
Thanks
I've got a table stored as an .mdf in visual Studio
The field is set to datetime
I'm inputting values from a combo box (selecting time in 15 bunches)
But when it adds the time to the record the date is still displayed in the field
What do I need to change to make it just display the time in the records with no date
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help...even on a Sunday!
ASKER
Your solution looked a little tricky, but you put me on the right track -
I've decided to just change the field at form end of things.
So on the form with the record set -Edit columns - appearence - default cell style =
DataGridViewCellStyle { Format=t }