In Form data is reflecting but not getting stored in table

[7201aks]

I have created a form to convert Hex to Dec
I have created control source as

=HexToDec([Hexadecimal Number])

for the Dec number, now the issue is in respective table Hex data is getting saved but in Decimal data field nothing is stored.

Please HELP!!!

[June7]

Why save? The value can be calculated whenever needed. Saving calculated data requires code (macro or VBA) in some event.

[7201aks]

can you help me?

I want to show the Decimal number on form and want to store the same in table

[June7]

Saving calculated data is usually not justified. The raw and calculated data can get 'out of sync'. A simple calc like this can be done when needed. However, if you insist, code in the Hex textbox AfterUpdate event can be like:

Me!Dec = Me.tbxDec

or

Me!Dec = HexToDec([Hexadecimal Number])


Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

[7201aks]

Thanks!!
Working now..