Search results for query: *

PH, When I run the code you provided, it gets stuck in the loop and highlights everything in the client file. Skip, When I run the code you provided, I receive a Compile Error: Variable Not Defined for the lRow = reference. I greatly appreciate your suggestions. Any thing else you can...

I am creating a macro that you open while in a client file to search for matches on a Do Not Contact (DNC) Listing. I want the macro to do the following: 1) Open and Sort the Do Not Contact Listing 2) Use a Do...Until Loop to move through the data on the DNC List and an embedded If...Then...

Duane, I finally figured it out with bits and pieces of answers from programmers and a little ingenuity!!! I set the control source for the Question text box to: =IIf([q1] Is Null, "", "Question Text") and the control source for the Answer text box to: [q1] I then set the Question text box...

Duane, Thanks for your response!!! This does allow the text boxes to shrink. However, when fields are not null, the data shows up twice. Once in the makeshift label and once in the text box itself. This is because I need to have 2 text boxes for each field in the following format...

I set the Can Shrink property of the controls = Yes and made sure that there aren't any controls to the left or right. I saw your answer to a similar question on the Access Database Reports Newsgroup and tried your suggestions. I also tried setting the field heights to 0.0007", each line top...

I have a report that is based on a query and the report prints out 1 page for each record. How can I suppress null fields for a record, so that they do not print on the report, and have any subsequent fields move up on the page?