in a letter which is in reality a report. The text box in which this is set has the CanGrow and CanShrink set to YES.
So when a part of the addressing fields were empty it automatically closed up the white s[pace.
Everything in the garden until last week was rosie until the accounts dept suddenly had a "great idea" and started to place the words " No local" in empty address fields. This of course means that now I get
Any ideas how I can make do the same process but looking for No Local and shrinking this OR something else
I'm pretty stuck now
I've been trying to think of a more elegant solution over the last 15mins, but nothing impressive springs to mind. I'm almost certain we can get a much better way of doing this - but as you said - sometimes you just want something that you know works!
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
You will want to change the code in the AddressBlock function. I would suggest possibly a SELECT statement to convert No Local and any other variations (there will be variations) of No Local to null. Then as you notice more bad data (No Locl, NoLocal, No Lo, etc.) you can just add them.
To be quite frank the contact details are a waste of time. What is anyone going to with do this rubbish like this. To me its better to let this record go. The consequences are US Mail will reject the any mail and the user who made this enter should get a kick up the pants.
I would not worry about the consequential effects but direct your attention to the input. If I found some-one entering this information I would report the rubbish to a superior because contact information is critical and this type of shoddy entry has no value to the business.
Try testing "No Local" on the entry screen "Address" field or even oncurrent
if(.[address] = "Nolocal" then
Msgbox "Don't be such a wally"
I wish that it was that simple - there is NOTHING I'd like more that to implement your suggestion. However, the introduction of "NO LOCALITY" is at the demand of a Government agency (yeh say no more). And also for the sheer proffessional finsh I wont let it just appear.
So you see, come what may its "goin ta happen"....
BY the way Thanks everyone who responded - I'll look at each options and see what I come up with