Convert unit on data entry

[octsim]

Hello there,

I have a simple question about data entry and performing some mathematical operations before storing the entered data.
I have a data entry form where I want the users to put in some values but I want to perform a unit conversion before storing the data. Is that possible? If yes - can you guys point me in the right direction?



Thanks in advance!

[pbaldy]

Like this?

http://allenbrowne.com/casu-14.html

[octsim]

Thanks, yes basically like that but I don't think it will work for what I want to do.
From what I understand, it's better to just use a query to update values in my tables.
The method explained for Access 2010 would be perfect but that would mean I have to create an additional field for each field I want to convert.
I have 12 fields in my table that the user will enter in mAh - I just want Access to store it directly in Ah (*1000). I have thought about running a query every time after I store data but I don't think I can create a query which just updates values I have just entered and it will multiply all other values with 1000 as well.
If creating 12 additional fields as calculated fields is the only way, I'll do that but I thought there might be a more "elegant" way to do this.

[pbaldy]

How about code in the after update event of each control that changes the value entered?

[octsim]

Thanks, that's exactly what I was looking for!

[pbaldy]

Happy to help!