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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | projecttodayStarting 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:00How can I get rid of the extra :00?  Why should it do this if it's Short Time?Robert |  |  
                                |  |  |  |