Solved

Tab Control and Combo Box Issue

Posted on 2014-02-21
13
505 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:Skip Sleeper
[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
  • 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:Skip Sleeper
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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:Skip Sleeper
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
 
LVL 37

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:Skip Sleeper
ID: 39877776
Thank you so much--I really appreciate it!
0
 

Author Comment

by:Skip Sleeper
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:Skip Sleeper
ID: 39882342
Very thorough, timely and precise as well extremely gracious when I awarded myself 500 points for accepting the solution!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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.

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