Solved

Tab Control and Combo Box Issue

Posted on 2014-02-21
13
502 Views
Last Modified: 2014-02-25
Hi Experts,

I have created a tab control on a form with a subform on the tab control and a combo box the subform (please see frmMenuCreator on attached db).  I have three issues that are probably related to not selecting the correct control to change, but I just don't have a clue at this point.  Any help would be greatly appreciated!

1.  The combo box in form view doesn't display the formatting I've designated

2.  The combo box shows filtering options in each column's heading.  I'm assuming this is being "inherited" somehow from the query but can't seem to find a solution to disabling it

3.  All the pages of the tab control display the subform and combo box.  How do I create different controls on the separate pages?

Thank you!
Menus-Working-version.accdb
0
Comment
Question by:fargus47
  • 6
  • 5
13 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 39877202
1 & 2:  Which combo box(es)?  It might help to post a screen shot or two to clarify the issue you are having.

3.  The problem is that your subform is on top of the tabcontrol, not "in" any of the tab pages.  Correct placement is a little tricky.  You have to
    - Click on the tab page you want the control(s) on
    - Click the edge of the page to select it (so that the page, not the whole tab control is outlined showing that it is in selection)
    - Click your heels together three times
    - Paste or place your controls onto the tab page.

I've done it here... just for demonstration I've placed it on the lunch tab (you can move it as needed)
Menus-Working-version.accdb
0
 

Author Comment

by:fargus47
ID: 39877247
Hi Mbizup-

Thank you for responding so quickly!  Attached please find the requested screen shot.  Also, is the heel clicking a special utility I can download? :)

Also I've got the tab control now--knew it must have been something "easy"!
frmMenuBuilder-Screen-shot-of-he.docx
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39877304
<<
Also, is the heel clicking a special utility I can download? :)
>>

I wish!

<<  Attached please find the requested screen shot. >>

I see what you mean... looking into it now, and scratching my head along with you at the moment.  It doesn't seem to be controlled by the properties I would normally use for this.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39877313
Hmm... Actually it is working as I would expect I was just looking at it wrong.

Open your subform in Design View, select one of the checkboxes, and change its  Data Sheet Caption property,

Datasheet Caption
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39877390
<< 2.  The combo box shows filtering options in each column's heading.  >>

I missed this earlier.  

To get rid of the sorting/filtering options drop-down in the column headers,

- Open the form in design view
- Open the form's property sheet
- Under the "Other" tab, set the Shortcut Menu Property to NO
- Save the changes (the change wont be apparent if you immediately switch back to Form View)

Change this to NO
0
 

Author Comment

by:fargus47
ID: 39877493
Hi,

How do I format those headings and have the formatting for the combobox take affect (e.g. font/size/weight)?  Am I looking at the wrong control?

Also, do you know of a source that defines/explains what the various properties are?


Thanks!
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39877770
You can't format the headings in the datasheet view using the interface.  You might be able to format at run time with VBA but I doubt it.  I had a list of properties that you could reference in datasheet view from VBA but I don't have it with me so couldn't post until tonight or over the weekend assuming I can find it.

If you change the view to continuous, you will be able to format the headers but you'll probably need to rebuild the form since the two form types are built differently.  The datasheet form view wizard builds the form with the fields listed in the detail section vertically with labels attached.  To use continuous view, you would want the labels in the report header section organized horizontally and the textboxes in the detail section also organized horizontally.
0
 

Author Comment

by:fargus47
ID: 39877776
Thank you so much--I really appreciate it!
0
 

Author Comment

by:fargus47
ID: 39879562
I've requested that this question be closed as follows:

Accepted answer: 0 points for fargus47's comment #a39877776

for the following reason:

Quick, Very thorough and precise!
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39878106
Glad to help out!

Check the way you are closing the question though, it looks like you are accidentally accepting your own comment as the solution.  :-)
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39879563
Posting an Objection to stop the pending closure and to get a Mod to help you out with this.
0
 

Author Closing Comment

by:fargus47
ID: 39882342
Very thorough, timely and precise as well extremely gracious when I awarded myself 500 points for accepting the solution!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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.

911 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

19 Experts available now in Live!

Get 1:1 Help Now