Solved

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

Posted on 2011-09-08
4
210 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:ssmith94015
  • 3
4 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
better to use the mouse down and mouse up event to toggle the appearance of the label

Private Sub Label0_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Label0.SpecialEffect = 2
End Sub

Private Sub Label0_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Label0.SpecialEffect = 0

End Sub
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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.
0
 

Author Closing Comment

by:ssmith94015
Comment Utility
Cap, mouse down worked perfectly.  Thank you

Sandra
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now