Convert decimal number to minutes

[Henley12]

I have a form in which people enter the time it takes to do a particular job. Of course, it works just fine if they enter the number of minutes, but is there an easy way to convert a decimal number into minutes? For example, on the After Update event of the field, if they enter 3.5, it will convert that to 210. How do I go about doing such a thing?

 

[pbaldy]

3.5 times 60 = 210

 

[pbaldy]

Or are you saying if they enter a decimal as opposed to an integer?

If Me.Textbox - Int(Me.Textbox) > 0 Then
  Me.Textbox = Me.Textbox * 60

 

[Henley12]

Ok. Now, I am using Access 2007 and the stupid thing is automatically rounding my number. How do I stop that?

 

[pbaldy]

The most common cause of that is a data type in the table of integer or long integer. Those can only take an integer value, as their name implies.