Use Command Buttons to change format of a field in a form

[khaos09]

Hi,
Is there a way to use a command button or VBA to change the format of a field in form? Sometimes my customer will need to enter a currency and sometimes they have to enter a percentage due to their health plan. I want to have two buttons one that changes the field into currency and the other changes the field to percentage (unless anyone has another idea).

Any help would be appreciated.

Thanks!

 

[SydneyGeek]

You should not mix data types in the same field.
Instead, have a Currency field and a Percentage field. You can change their visibility with a button, and they can be overlaid so the user doesn't have to move to a different part of the form.

Denis

 

[khaos09]

Thanks! That is a really good idea, I just implemented the process and its works well.