A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form Open



 
 
Thread Tools Display Modes
  #1  
Old October 3rd, 2006, 07:15 PM posted to microsoft.public.access.forms
Niniel
external usenet poster
 
Posts: 582
Default Form Open

Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.
  #2  
Old October 3rd, 2006, 07:24 PM posted to microsoft.public.access.forms
Wayne-I-M
external usenet poster
 
Posts: 3,674
Default Form Open

Hi Niniel

Open the form in design view and select the View menu. Select tab order.
The order in which fields are selected with the tab key is designated in
this list.

The 1st field that you want (as you say the oone at the top of the form)
should be Tab Order 0, next 1, then 2, etc.

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.

  #3  
Old October 3rd, 2006, 07:27 PM posted to microsoft.public.access.forms
Niniel
external usenet poster
 
Posts: 582
Default Form Open

Ok, let me rephrase that.
This is actually not my problem as I found out when I realized that a simple

Me.TextBox.SetFocus

sets the cursor.

My real problem is that when I open the form, it's scrolled down a bit, and
I don't see the tabs of my tab control.
So again - what causes this behaviour, and how can it be fixed?

Thanks.

"Niniel" wrote:

Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.

  #4  
Old October 3rd, 2006, 07:27 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Form Open

Niniel

Open the form in design mode.

Click on menu item "View", then "Tab Order".

Change the tab order of the controls so that the top-most control on the
form is the first in the list.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Niniel" wrote in message
...
Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see
the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.



  #5  
Old October 3rd, 2006, 07:34 PM posted to microsoft.public.access.forms
Wayne-I-M
external usenet poster
 
Posts: 3,674
Default Form Open

When I open my form, the cursor is not in the first text field, but in one
halfway down the form,

This tells me the setfocus code is not working.

Remove the code and then set the tab order.

Next open you form in design view. Can you see the form as you want it -
ie. can you see the tabs. If not move them and then press Control S.

Let me know if these work. :-)

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Ok, let me rephrase that.
This is actually not my problem as I found out when I realized that a simple

Me.TextBox.SetFocus

sets the cursor.

My real problem is that when I open the form, it's scrolled down a bit, and
I don't see the tabs of my tab control.
So again - what causes this behaviour, and how can it be fixed?

Thanks.

"Niniel" wrote:

Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.

  #6  
Old October 3rd, 2006, 07:51 PM posted to microsoft.public.access.forms
Niniel
external usenet poster
 
Posts: 582
Default Form Open

Wayne, the set focus code was working, it's just that when I got it to work I
realized that the focus wasn't the real issue.
However, I'm glad you mentioned the tab order, I went there and rearranged a
few things.
What happens is that in design view, I can see the tabs all right. But the
moment I switch to form view, the form scrolls down a bit to just below the
tabs so that I don't see them.

Do you think putting an invisible text field in the form header and setting
the focus to that may do the trick?

"Wayne-I-M" wrote:

When I open my form, the cursor is not in the first text field, but in one
halfway down the form,

This tells me the setfocus code is not working.

Remove the code and then set the tab order.

Next open you form in design view. Can you see the form as you want it -
ie. can you see the tabs. If not move them and then press Control S.

Let me know if these work. :-)

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Ok, let me rephrase that.
This is actually not my problem as I found out when I realized that a simple

Me.TextBox.SetFocus

sets the cursor.

My real problem is that when I open the form, it's scrolled down a bit, and
I don't see the tabs of my tab control.
So again - what causes this behaviour, and how can it be fixed?

Thanks.

"Niniel" wrote:

Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.

  #7  
Old October 3rd, 2006, 08:02 PM posted to microsoft.public.access.forms
Wayne-I-M
external usenet poster
 
Posts: 3,674
Default Form Open

In design view you have (if you have selected them) full menus and you may
not have these in form view. Turn off the menus in design view so that that
the form you see is the form you will get. Also turn off auto centre if it
is set to Yes.


--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Wayne, the set focus code was working, it's just that when I got it to work I
realized that the focus wasn't the real issue.
However, I'm glad you mentioned the tab order, I went there and rearranged a
few things.
What happens is that in design view, I can see the tabs all right. But the
moment I switch to form view, the form scrolls down a bit to just below the
tabs so that I don't see them.

Do you think putting an invisible text field in the form header and setting
the focus to that may do the trick?

"Wayne-I-M" wrote:

When I open my form, the cursor is not in the first text field, but in one
halfway down the form,

This tells me the setfocus code is not working.

Remove the code and then set the tab order.

Next open you form in design view. Can you see the form as you want it -
ie. can you see the tabs. If not move them and then press Control S.

Let me know if these work. :-)

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Ok, let me rephrase that.
This is actually not my problem as I found out when I realized that a simple

Me.TextBox.SetFocus

sets the cursor.

My real problem is that when I open the form, it's scrolled down a bit, and
I don't see the tabs of my tab control.
So again - what causes this behaviour, and how can it be fixed?

Thanks.

"Niniel" wrote:

Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.

  #8  
Old October 3rd, 2006, 08:25 PM posted to microsoft.public.access.forms
Niniel
external usenet poster
 
Posts: 582
Default Form Open

I did all this, no change.
Actually, the number of menus seems irrelevant, they just push the entire
form down. When I deselect menus, and then open the form, there's just a gap
between form and menu bar.
No, it must be something in the interaction between form and tab control.

"Wayne-I-M" wrote:

In design view you have (if you have selected them) full menus and you may
not have these in form view. Turn off the menus in design view so that that
the form you see is the form you will get. Also turn off auto centre if it
is set to Yes.


--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Wayne, the set focus code was working, it's just that when I got it to work I
realized that the focus wasn't the real issue.
However, I'm glad you mentioned the tab order, I went there and rearranged a
few things.
What happens is that in design view, I can see the tabs all right. But the
moment I switch to form view, the form scrolls down a bit to just below the
tabs so that I don't see them.

Do you think putting an invisible text field in the form header and setting
the focus to that may do the trick?

"Wayne-I-M" wrote:

When I open my form, the cursor is not in the first text field, but in one
halfway down the form,
This tells me the setfocus code is not working.

Remove the code and then set the tab order.

Next open you form in design view. Can you see the form as you want it -
ie. can you see the tabs. If not move them and then press Control S.

Let me know if these work. :-)

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Ok, let me rephrase that.
This is actually not my problem as I found out when I realized that a simple

Me.TextBox.SetFocus

sets the cursor.

My real problem is that when I open the form, it's scrolled down a bit, and
I don't see the tabs of my tab control.
So again - what causes this behaviour, and how can it be fixed?

Thanks.

"Niniel" wrote:

Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.

  #9  
Old October 3rd, 2006, 08:32 PM posted to microsoft.public.access.forms
Wayne-I-M
external usenet poster
 
Posts: 3,674
Default Form Open

With your form in form view
select
View
Toolbars
Deselect Form View
Deselect Formating

I can't see your form so just going through all the items that "may" move
the form around on your screen.

It will work - eventually.

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

I did all this, no change.
Actually, the number of menus seems irrelevant, they just push the entire
form down. When I deselect menus, and then open the form, there's just a gap
between form and menu bar.
No, it must be something in the interaction between form and tab control.

"Wayne-I-M" wrote:

In design view you have (if you have selected them) full menus and you may
not have these in form view. Turn off the menus in design view so that that
the form you see is the form you will get. Also turn off auto centre if it
is set to Yes.


--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Wayne, the set focus code was working, it's just that when I got it to work I
realized that the focus wasn't the real issue.
However, I'm glad you mentioned the tab order, I went there and rearranged a
few things.
What happens is that in design view, I can see the tabs all right. But the
moment I switch to form view, the form scrolls down a bit to just below the
tabs so that I don't see them.

Do you think putting an invisible text field in the form header and setting
the focus to that may do the trick?

"Wayne-I-M" wrote:

When I open my form, the cursor is not in the first text field, but in one
halfway down the form,
This tells me the setfocus code is not working.

Remove the code and then set the tab order.

Next open you form in design view. Can you see the form as you want it -
ie. can you see the tabs. If not move them and then press Control S.

Let me know if these work. :-)

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Niniel" wrote:

Ok, let me rephrase that.
This is actually not my problem as I found out when I realized that a simple

Me.TextBox.SetFocus

sets the cursor.

My real problem is that when I open the form, it's scrolled down a bit, and
I don't see the tabs of my tab control.
So again - what causes this behaviour, and how can it be fixed?

Thanks.

"Niniel" wrote:

Hello,

When I open my form, the cursor is not in the first text field, but in one
halfway down the form, which is a problem because the user needs to see the
top of the form.

Can anybody tell me why this is so, and how I can make sure that the very
first text box has the focus when I open the form?

Thank you.

  #10  
Old October 3rd, 2006, 08:44 PM posted to microsoft.public.access.forms
Niniel
external usenet poster
 
Posts: 582
Default Form Open

Thank you for your patience.
However, I may not have described the issue well and caused a
misunderstanding. Sorry about that.
It's not that the top of the form is hidden by the menus. It's that the
form, which doesn't fit the screen so there are vertical scroll bars, scrolls
down on it's own, so to speak. Just enough so that the tabs of the tab
control, which is on the form, are invisible immediately after opening the
form. A user might not even realize that they are missing and he has to
scroll up to see them.

The same thing actually happens every time I switch from Design view back to
Form view.

"Wayne-I-M" wrote:

With your form in form view
select
View
Toolbars
Deselect Form View
Deselect Formating

I can't see your form so just going through all the items that "may" move
the form around on your screen.

It will work - eventually.

--
Wayne
Manchester, England.
Enjoy whatever it is you do


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.