How to display a form but select nothing?

Big Pat

Registered User.
Local time
Today, 12:48
Joined
Sep 29, 2004
Messages
555
My users have asked for a form to display various database statistics, as they prefer this to a report. I have designed a form which contains several DLookUps and some sub forms. But several areas on the form display "white", as if they are being selected by deafult.

For each area/element/text box, I have set the Tab Stop and Auto Tab properties to No. Each background and border is also transparent. Is there some other setting I need to adjust, whether at the main form, subform or individual text box level?

The form works fine, it just doesn't LOOK very professional and I'm keen to improve how I do things. Please see attachment. Thanks.
 

Attachments

  • form.jpg
    form.jpg
    50.6 KB · Views: 326
Pat,

Open the subforms in design view, in the section of the form (Detail, Header, Footer) that is giving you the problem put a command button (Turn the Wizard off) Give it a name cmdDudDetail, click Format and set Transparent to YES.
Now in the Tab Order for Detail move the cmdDudDetail to the top. Now when your users open the "Main" form all the subforms Tab Order will be directed to your cmdDud's.

I have attached a sample of how it works. I use it a lot because I do not like the highlighting of controls.

When you open the form in design view in my sample you will see a square to the right of the auto number thats the command button.
 
Last edited:
Thanks, John

Beautifully simple. I wish I'd thought of that!

Thank you.

Pat
 

Users who are viewing this thread

Back
Top Bottom