Simultaneously view properties of Textbox1 and Textbox2.

Sometimes I want to simultaneously view and compare the properties of two controls.  

This is hard because MS Access shows properties one at a time.  This is true even when I open two databases and arrange one on monitor 1, and the other on monitor 2.

I have found two workarounds:

1) use the snipping tool to grab one set of properties, then use Access to view the other.

2) use Msttsc to rdp to another computer so I see two computer on my desktop.  This provides the most flexibility, but sometimes there is not another computer handy.

Does anybody have other options?
LVL 5
rberkeConsultantAsked:
Who is Participating?
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
you have found the solutions that I know of, and VM too. Most often I just take a screen shot of it, and I do that a lot.

even if you have 2 Access apps open, there will be only one property sheet window that will show unless it is docked. I like to float the properties window, but the disadvantage is that when you click away from Access, it disappears.

If both controls are selected, the Property Sheet will show values they have in common.
0
 
PatHartmanConnect With a Mentor Commented:
I use the snap tool or I open the database as read only on my other monitor.  I also NEVER use tab view which exacerbates the problem of only being able to one thing at a time.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
I use # 1  all the time - Snagit !
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Gustav BrockConnect With a Mentor CIOCommented:
You can create a (read-only) copy of the database and open that in a second instance of Access.
0
 
rberkeConsultantAuthor Commented:
#1 What is the "snap tool"?

#2 I had never noticed that docked properties work differently from the floating view.  

Thanks to you guys, I now simply copy FE.MDB to FE2.MDB.  I only dock the tool bar on FE2.  I can then drag the FE  properties right next to the FE2 properties.  I can then use snagit's "Grab text" tool to grab the values for pasting into excel which I can do further documentation.

It does seem to matter if either one is Read Only, so I probably won't bother doing that.  Nonetheless, it might be a good idea to avoid accidentally changing the wrong database.

#3 I believe the follow clarification is accurate regarding
If both controls are selected, the Property Sheet will show values they have in common.
   The FE.mdb property sheet is not affected by the selected controls in FE2.  
     Example:
     In FE.mdb label1 and command2 are selected,  FE2 has a form1 selected.
     lbl1 has 6 properties on the "Other" sheet, while cmd2 has 12.  The intersection has 4 properties.
     These 4 common properties are: ControlTip Text; Shortcut Menu Bar; Help Context Id; Taq
     
     The FE.mdb property sheet will display all 4 common properties, but the value will only show if they match.
     For instance, if lb1.ControlTips  is "Click Here" and cmd2.ControlTip is "Delete row", the property sheet show no value..
0
 
PatHartmanConnect With a Mentor Commented:
#1 - you said you were using it.
#2 - it is dangerous to have two updateable copies open at once.
#4 - selecting multiple controls only works in a single database.  The two open databases are completely separate in memory so selecting controls in both would not merge the property list.
0
 
rberkeConsultantAuthor Commented:
Crystal was the first to mention docking the property sheet, so I am giving her best answer.

All other responders were also helpful.

BTW, I said I was using a "snip tool", so that is why I was confused by the "snap tool" comment.  But, now I understand they are referring to the same thing.

Thanks to all
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.