Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Short time format

Author  Topic 

projecttoday
Starting Member

31 Posts

Posted - 2010-03-01 : 19:01:57
I am in the process of converting an Access database to SQL Server Express 2008. I have made an Access ADP. I have a form which has a textbox on it which displays and updates a time field using a stored procedure. The field in the database is time(0). The format of the textbox is Short Time. The input mask of the textbox is Short Time. But it displays as:

00:00:00

How can I get rid of the extra :00? Why should it do this if it's Short Time?

Robert
   

- Advertisement -