asked on

Use label click to open form, but need to have lable change somehow

I have several lables that when the user clicks , various forms appear. However, there is a few second's delay and whie I know that the form will come up, an end-user won't. Is there anyway to change teh appearance of a label when it is click so the user knows? This is Access 2003 form.

Rey Obrero (Capricorn1)

you can use the click event of the label, and combination of property setting ,border width etc

an example is

private sub label0_click()

me.label0.specialeffect=2

end sub

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rey Obrero (Capricorn1)

here are the values of the special effect property

The SpecialEffect property uses the following settings.

Setting Visual Basic Description
Flat 0 The object appears flat and has the system's default colors or custom colors that were set in Design view.
Raised 1 The object has a highlight on the top and left and a shadow on the bottom and right.
Sunken 2 The object has a shadow on the top and left and a highlight on the bottom and right.
Etched 3 The object has a sunken line surrounding the control.
Shadowed 4 The object has a shadow below and to the right of the control.
Chiseled 5 The object has a sunken line below the control.

Sandra Smith

ASKER

Cap, mouse down worked perfectly. Thank you

Sandra