I have a database of electronic components. For capacitors the software using the data wants a Real number for the value so as an example a 1uF capacitor needs to be entered as 0.0000001 and a pF as 0.000000000001.
I set up the form with a Value field, Farad field and a ValueR field.
the form is filled as (example):
Value |Farad | ValueR |
| .1 ..| ..u ..| ............|
I added a calculated field "ValueRr" in a form: =IIf([Farad]="u","0.0000001"*[Value],IIf([Farad]="p","0.000000000001"*[Value]))
Then added a button to copy the result to the ValueR Field: Forms!cap_smd.ValueR.Value = Forms!cap_smd.ValueRr.Value.
This works if the ValueR field is a text field but the software needs to see it as a number. If I change it to a number type, the ValueR field displays "0".
How can I get this to work or is there a better way to solve this? I couldn't find a way to have the result put directly into the ValueR field