Convesions on forms

[Scimitar]

Sorry if I've posted this in the wrong place.

I'm currently trying to create a database in MS access. I have all the tables and forms working correctly but simply. My problem is one field on the form I have created requires a number of kilometres, but the data collected is in miles (there's no way around this that's just how it is). I want to be able to input the miles on to this form and access to do the conversion automatically. However, I have no idea how to achieve this. Anyone got any ideas?

Cheers

Al

 

[rainman89]

make a seperate unbound text box whos control source is

=miles to km conversion using the [miles] field from your table

 

[Scimitar]

Hi

Thanks for the reply. I'm relatively new to this and I'm not entirely sure how to implement what you've told me.

Al

 

[rainman89]

heres a quick example. look at the afterupdate event of the miles box