Search results for query: *

My boss wants me to have the option of driving my "add client" form by my "sort query". Is there a way to do this without creating a totally new form (the new form- if necessary- would have to look exactly like the "add client"- which is moderately complex imo)? If I had to, I guess I could...

Thanks Trevil- however I tried the Shrink and Grow already and it doesn't seem to make much difference. It actually adds the cutoff info to the next line down e.g. ChristophConklin er As far as concentrating the two fields, how would I go about doing that?

In my Mailing Label report I have two boxes next to each other (and several other boxes above and below which all work out fine) First Name Last Name How do I code it so that they are both in the same box? If I can figure this out it will prevent there from being a large space between them if...

Ok, the only problem is that when I = [Forms]![Sort]![Contact] Or Trim([Forms]![Sort]![Contact] & "") = "" for 8 parameters, the "query is too complex" error pops up. :(

However, the second choice of = [Forms]![Sort]![Contact] Or Trim([Forms]![Sort]![Contact] & "") = "" Does work! Thanks, I been trying to figure this pickle out for awhile now, this is a HUGE help ;)

Like NZ([Forms]![Sort]![Contact], "*") as the criteria for Contact and Like NZ([Forms]![Sort]![Contact], "*") I get the appropriate table return if I enter form values for both, but if either is missing then it returns an empty table...

I'm drawing values for my parameter query from a form with drop down boxes. What I want is for the query value to be drawn from the drop-down box, or if the drop down is left as blank then "*" wildcard for all data. There will be many drop-down boxes that relate to different parameters, so I...