Solved

How make labels NOT visible if new record on a form

Posted on 2014-01-20
5
309 Views
Last Modified: 2014-01-23
I have two labels I want to not be visible when a form opens for a new record entry.

How can I do this?
0
Comment
Question by:SteveL13
  • 2
  • 2
5 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 250 total points
ID: 39794945
place this codes in the open event of the form

me.label1.visible=not me.newrecord

me.label2.visible=not me.newrecord
0
 
LVL 30

Accepted Solution

by:
hnasr earned 250 total points
ID: 39794961
Only the label?
Making field invisible, hides the label as well.
0
 

Author Comment

by:SteveL13
ID: 39794964
Actually one is a label and one is a combobox.  I tried this but they are both still visible when the form opens for a new record.

    Me.Combo125.Visible = Not Me.NewRecord
    Me.FindRecordLabel.Visible = Not Me.NewRecord
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39794974
Try the code in Current event.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39794976
are you sure the form is on new record?
try also the load event of the form
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

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…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

856 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