numeric data from database always displays as a date???

Hi,
I was wondering if anyone can shed any light on the followong (not sure if it's an Access or Vb problem).

I am using an Access database with a field with numbers in in the format 00:00.0 (i.e 01:32.46 )
When I add this field to my form ( I have tried textbox, masked textbox set to 00:00.0, datetimepicker, datagridview) I get a date of 30/12/1899 00:01 displayed all the time.

Also when I preview data it displays the same. I've also tried changing the data type(from the data source window, right clicking on the field and customise, then setting data type to various types) but this seems to default back to "date time" all the time after clicking ok and checking it again( I think this maybe the problem)

Is this a formatting problem with access or VB, I can't find anything in either to fix this, it's driving me mad. All I want is to display whats in the field and thats it...

any help would be much appreciated

Thanks
lee

Answer this question

numeric data from database always displays as a date???

luoo

Oooooohhhh Lee something looks very familiar about that. That looks like a computer reference date.

I'm worndering if the value you have is not 0. I don't think it's ever been filled in.
Arik Cohen - msft
AAAAhh,

I think I may have sorted it!!!

I found the formatting option in access...

cheers
Mick_RW
Lee,

In Access - what is the data type of this field and its properties (field size, format, etc). The format you are specifying looks like Minutes:Seconds and hundreds of seconds, so someone (vb or ado) is interpreting it as a datetime.

Adam
Dot Net Engineer
hi,

Yes it is minutes, seconds, hundreds

Ok, so how do I fix it

I can't find anything in access to set the format type of the field..

Do you think then it's definetly a setting in access and not a problem with VB

cheers Lee
numeric data from database always displays as a date???

Answer this question