Search results

No, it isn't worth it. I am just going with vertical scroll bars for now and letting the users get "comfortable" with that. Thanks for your assistance.

Yes...the vertical scroll bar works but it seems asthestically correct if the field could be the size of the data.

I created a "search" form that contains a textbox which is set up as 4" wide. However, there will be times when the data will be longer than 4" hence, I want to apply CanGrow so that the textbox will grow vertically to accomodate all data. I realize that CanGrow does not work in form view, I...

Cancel=true works like a charm! Thanks for your help! Sam

This field will be required, no matter what...either for a new record or as a source of a search.

Actually, under your method, I can still tab out of the field. The point with what I am doing is to actually prevent someone from tabbing out simply by refocusing them back. As for updating the record, I am doing this via command button.

I have encountered a very strange situation which I am wondering if any of you have an insight to. I have a form for which the first field is a bounded combobox (MOD_ID) must be filled. The value can either be entered by the user or selected from a table. In my onExit for this field, I...

Thanks Doug...it worked like a charm!

I have a form that performs either a preview or print report. However, before the actual report can be executed (previewed or printed), I need to perform a make-table query. How do I go about coding the form so that the make-table query performs before the preview or print executes? Thanks!

Gee thanks Rich...thats a great big help!

I am really green with this so bear with me, please. I have been charged with creating a form for which a user inputs values into 4 fields. The user will then receive back values of 5 fields based on the input. I have designed a query for this purpose. How can one use the 4 input fields as...

I am running Access 97. I have a very large report that could exceed 1000 pages. When I execute the report, I get the first page and I am able to scroll through each subsequent page, one by one. However, when I click on the arrow that will take me to the last page, the formatting report bar...

I have a form that has command buttons to either (1) preview report, (2) print report, or (3) output to file. I have also added an option group which for Detail or Summary. My question is... How do I get the detail or summary to pass values to the report detail section so that the Visible...

Thanks Rich!

I have a report which combines the results of a query with "test". For example, =RTrim([CS or Inst]) & " Employment/Affirmative Action Personnel Changes" There are times when the query does not return any records and because of such, #Error will display. How can I prevent #Error and...