Solved

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

Posted on 2011-09-08
4
220 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36504445
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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 36504467
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36504489
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
ID: 36504547
Cap, mouse down worked perfectly.  Thank you

Sandra
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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 the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

734 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