Two different input formats for same column

[Vera]

Hi,

Is it possible to have two different input formats in one and the same column.
I have a column account number which has a format of 000-0000000-00.
With the new IBAN number, the format changes. For the numbers that are already in the column, nothing changes, but for new numbers the format will be: AA00 0000 0000 0000

I intend to have a option button on the form asking if it's IBAN or not, if IBAN, I want that format, if not, the old one stays.
Is this possible?

Thanks.
Vera

[Rawb]

You can do some limited data validation at the Table-level, but you can't allow for multiple formats like that in a single field.

You can control that programatically through the input Form though.

[weekend00]

you may try to set different input mask on that field when user choose different type.