OR statement in an input mask?

[Guest]

Is it possible to use an OR statement in the input mask
to allow two different data formats in one field on a
form? Everytime I try it takes the OR as a literal text
and it shows up in the entry field.

TIA

 

[Pat Hartman]

No, there is no reason to provide that type of functionality since each
column should only hold a single type of data.

 

[Douglas J. Steele]

In all fairness to the original poster, I can conceive of situations where
you'd be storing a single type of data in a field, but it could have a
number of different formats. For example, you might need to store US Zip
Codes, Canadian Postal Codes and UK Postcodes in the same field, and each
have a very different format. The same is true of telephone numbers.

That having been said, your answer of "No" is correct.

 

[Guest]

-----Original Message-----
In all fairness to the original poster, I can conceive of situations where
you'd be storing a single type of data in a field, but it could have a
number of different formats. For example, you might need to store US Zip
Codes, Canadian Postal Codes and UK Postcodes in the same field, and each
have a very different format. The same is true of telephone numbers.

That having been said, your answer of "No" is correct.

Thank you for the answer, the situation was one of
account types (internal vs. external)