I just did a search for what I'm trying to do but haven't had any luck.
I have a text field in a report (Access 2000 SR-2) that contains numeric and alpha information. Let's call the field "Code". Any valid "Code" starts with a numeric value, however, invalid codes start with an alpha character.
What I want to do is simply make the field null anytime one of the codes starts with an alpha character. You see, I don't want to eliminate that record or the rest of the data for that record from the report, just hide the invalid codes.
How can I do this in the Detail_Format section (or wherever) of the form? Or am I better using an IIF statement in the text field (control) on this report?
Dave <img src=/S/flee.gif border=0 alt=flee width=25 height=25>