Hi Richard,

Is there any way to create a conditional pseudo-input mask on a form?

We deal with various customers who have different mandatory requirements in order to process payments (e.g. purchase order numbers, claim numbers, etc.). Some of the customers require multiple (e.g. both a PO number and a claim number).

In order to minimise data entry errors, I would like to set up a method to ensure the data is entered according to each organisation's criteria. For example, customer #1 uses the following PO structure: 6046449, whereas customer #2 uses the following claim number format: CRI20100844498

Because each organisation have their own formats for these numbers, using a table level input mask would not work. I am thinking of setting up a table that helps validate the entry at the form field level (see example below).

agency_idpurchase_code_typepurchase_input_mask
1122Purchase Order Number0000000
1123CRI NumberCRI 00000000000
1124Purchase Order NumberL-000
1225Case NumberARV: 0000000

My question is, when entering an order for one of these customers, can a VBA function used to validate the mandatory purchase info has been entered in correctly?

I'd appreciate your input.

Thanks,

Leo Saumure