Formatting a field based on other data

[msmithtlh]

I have multiple ID types (FEIN, SSN, and 2 different internal department numbers) which can be used as the ID for a case (not the primary key. Primary key is a autonumber). However each of these have their own distinct format. When printing a summary sheet for each case, we want the ID type "FEIN," "SSN," "Cert," or "BP" printed and then the formatted value for that ID type.



I had this working pretty well up to a point. When adding a new record, I determined the id type, based on whether the user populated the FEIN field, the SSN field, the "Cert" field or the BP field, and saved the literal ("FEIN," "SSN," "Cert," or "BP") to a field called "id type" and then copied the value from the specific fields to a second field called "id text" and used the appropriate input mask based on the id type. So far, so good.

HOWEVER, when I was updating an ID (presuming that it had been entered incorrectly), I could not get the ID type field and ID text field to update correctly and format correctly.

I'm not sure if all this manipulation is the way to go,,,, or if there is a way to do some code or unbound fields on the summary sheet, that will pick up the field that has data in it and the appropriate formatting.

Thanks in advance!!

[June7]

Think I would not have multiple fields for these ID's, assuming a case can have only 1 of the 4 possible. Could use code in the AfterUpdate event of IDtype to set the input mask property of the IDtext box. Also have the IDtext box set as not Enabled until the IDtype is input and then code will set Enabled Yes. Can set the mask to save the value with punctuation so formatting of these values is not an issue for reports.

[msmithtlh]

That's a good approach. Thank you.