Link to home
Start Free TrialLog in
Avatar of davecocks
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
ASKER CERTIFIED SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of davecocks
davecocks

ASKER

Hey Gary thanks for your input, especially as its a Sunday!

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 }
Glad to help...even on a Sunday!