Aligning rows in combo box

W

Wendy

hello,
my issue is rather tricky.... i have a combo box with the following code
using the ".dropdown" option.

Private Sub Form_Open(Cancel As Integer)
Me![Topic_MCQ_Sub_ID].Visible = False
Me!frmTopic_MCQ_Subform.Visible = False
DoCmd.GoToControl "Topic_MCQ_Main_ID"
Me!Topic_MCQ_Main_ID.Dropdown

End Sub

The rows align neatly beneath the combo box if I'm in design mode and view
the form but when i call the form from my main menu, the rows appear
approximately 1inch below the combo box. Has anybody seen this behaviour
before and know of a remedy. I'm using Access2003. I've created a clean
database and created a few tables to test the feature but still get the same
result.

Many thanks for any help offered
 
W

Wayne-I-M

Hi Wendy

In design view click View and then toolbars. Uncheck the 5 options then
move your items to where you want them. This should work. - The reason may
be that in design view you have the tool bars open and if you position
absolutley you will only see the results when the design and Normall views
are the same.

If it doesn't

Open the form in normall view. Move the items to where you want them and
then press Control S.

Close and reopen. You should see the items where you want.
--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.
 
W

Wendy

Hi Wayne,

Thanks for the speedy response.

Have tried your suggestion but without any luck. The location of the combo
box is fine, it's the rows/contents (5 Items in the list) that don't align
with the combo box, they appear about 1/2 inch below the box and are
indented. Is there anyway i can submit a word document that contains images
of the problem?

once again, i really appreciate any assistance you can offer.

thanks

wendy


Wayne-I-M said:
Hi Wendy

In design view click View and then toolbars. Uncheck the 5 options then
move your items to where you want them. This should work. - The reason may
be that in design view you have the tool bars open and if you position
absolutley you will only see the results when the design and Normall views
are the same.

If it doesn't

Open the form in normall view. Move the items to where you want them and
then press Control S.

Close and reopen. You should see the items where you want.
--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


Wendy said:
hello,
my issue is rather tricky.... i have a combo box with the following code
using the ".dropdown" option.

Private Sub Form_Open(Cancel As Integer)
Me![Topic_MCQ_Sub_ID].Visible = False
Me!frmTopic_MCQ_Subform.Visible = False
DoCmd.GoToControl "Topic_MCQ_Main_ID"
Me!Topic_MCQ_Main_ID.Dropdown

End Sub

The rows align neatly beneath the combo box if I'm in design mode and view
the form but when i call the form from my main menu, the rows appear
approximately 1inch below the combo box. Has anybody seen this behaviour
before and know of a remedy. I'm using Access2003. I've created a clean
database and created a few tables to test the feature but still get the same
result.

Many thanks for any help offered
Click to expand...
Click to expand...
 
W

Wayne-I-M

Take the drop down off the On Open and also the go to control

Private Sub Form_Open(Cancel As Integer)
Me![Topic_MCQ_Sub_ID].Visible = False
Me!frmTopic_MCQ_Subform.Visible = False
End Sub

Set the Tab stop as 1 on [Topic_MCQ_Main_ID] - this set the focus on On
Open to this combo

Set this code behind the Combo Got Focus event

Private Sub Topic_MCQ_Main_ID_GotFocus()
Me.Topic_MCQ_Main_ID.Dropdown
End Sub

This will dropdown the combo on Open (as the Tab stop is set to 1)

Let me know if you have any luck with this




--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


Wendy said:
Hi Wayne,

Thanks for the speedy response.

Have tried your suggestion but without any luck. The location of the combo
box is fine, it's the rows/contents (5 Items in the list) that don't align
with the combo box, they appear about 1/2 inch below the box and are
indented. Is there anyway i can submit a word document that contains images
of the problem?

once again, i really appreciate any assistance you can offer.

thanks

wendy


Wayne-I-M said:
Hi Wendy

In design view click View and then toolbars. Uncheck the 5 options then
move your items to where you want them. This should work. - The reason may
be that in design view you have the tool bars open and if you position
absolutley you will only see the results when the design and Normall views
are the same.

If it doesn't

Open the form in normall view. Move the items to where you want them and
then press Control S.

Close and reopen. You should see the items where you want.
--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.


Wendy said:
hello,
my issue is rather tricky.... i have a combo box with the following code
using the ".dropdown" option.

Private Sub Form_Open(Cancel As Integer)
Me![Topic_MCQ_Sub_ID].Visible = False
Me!frmTopic_MCQ_Subform.Visible = False
DoCmd.GoToControl "Topic_MCQ_Main_ID"
Me!Topic_MCQ_Main_ID.Dropdown

End Sub

The rows align neatly beneath the combo box if I'm in design mode and view
the form but when i call the form from my main menu, the rows appear
approximately 1inch below the combo box. Has anybody seen this behaviour
before and know of a remedy. I'm using Access2003. I've created a clean
database and created a few tables to test the feature but still get the same
result.

Many thanks for any help offered
Click to expand...
Click to expand...
Click to expand...
 
W

Wayne-I-M

Also

Check there are no blank records at the top of the source (query) for the
combo as this would give the look of a black area below the combo heading.

Open the query to check this

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.
 
W

Wendy

Hi Wayne
Have created a combo box using the wizard and get the same problem. It
displays correctly using design/view from but the alignment is out when
opening the form from another form (Main Menu).

Thanks for you help, do you have any other suggestions. Are you able to
replicate the same problem?

Many thanks

Wendy
 
W

Wayne-I-M

Hi Wendy

I have tried to create the same problem that you are having and can't. I
have never heard of a combo box doing anything other than what it should. I
can not get a combo to "split" with the rows below the box - I didn't know
that you even could do this - I don't think you are meant to be able.

I'm too sure that this is an access problem - of course it "is" but it may
not be a codeing problem it may be a problem with your copy of access.

Have you tried to create a combo using the same code on a different copy of
access.



--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo :)
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.
 
W

Wendy

Hi Wayne
I've managed to futz the issue, although i still don't understand why it's
occurring. Basically on Load, i've used the "Sendkey" command to send an
"{Enter}" to the combo box, and then on the "Got Focus" i've used the
..dropdown. It appears to be working, not ideal, but as you've said in your
email below, it's abnormal behaviour. Is there anyway i can send you a
snapshot of how the combo box was displaying? As for your suggestion about
using a different copy of Access, I've been trying to solve this issue on my
home pc (Access 2003) and my work pc (Access 2000), both machines are running
xp.

thanks again for your help
 
W

wayne-i-m

I have just create a new hotmail account that you can send the DB to
PLEASE REMOVE ANY SENSATIVE INFORMATION before you send.


(e-mail address removed)

To all spamers.
Please send me loads of spam as after I have looked at wendy's message I
will never look at the mail account again and it will be deleted by hotmail
after 4 weeks of non-use.
 
W

Wendy

hi Wayne
Thanks for all your help. I've sent a pdf to the specified email address.
Thanks for looking into this further.

Wendy
 
W

wendy hubbard

Hi Wayne
sorry for the delay in replying (blaming it on sick 3yr old twins). the fix
you emailed worked fine and the gremlins have now disappeared. Many Many
thanks for all your help

Regards

Wendy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter on combo box possible? 1
2nd combo box criteria based on 1st combo box 0
Combo Box results to Subform 1
I want a text box to appear only when a combo box is set 3
Visibility dependent combo box 2
Access Combo Box question 0
combo box not visable on form when loaded from specific location 3
Combo Box Stops Working after Passing Data from Another Form 1

Top