>I have text field with ControlSource bind to table field. I would like to see the diffrent value in the field but still to save the original one.
>Ex:
>Total: US$300 (should show on the form) and should save CAN$477
>
>What is the best way of doing this?
>
>Thanks in advance
Don't bind to the table value but set up a form property to hold and display the required calculated value.
HTH