B
Byron
Is there a way to have an Access form automatically scroll down as fields are
filled? Thanks in advance for any assistance provided
filled? Thanks in advance for any assistance provided
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MikeJohnB
A form which is bigger than the viewable screen should scroll down as each
control lower than the viewable screen gain focus????
However, perhaps you want to jump the screen down further than one control?
The way i would do this should I require it would be to place an unbound
TextBox on the form adjacent to the next control which is below the viewable
screen or to where you want the screen to shift to. Set the Label of the text
box to Invisible (Not the Text Box itself) and set the width of the text box
to zero width (Width = 0cm). (You now have a practically invisible Text Box
on your form). The text box has a tab stop, use that to give the text box
focus when you have filled in the bottom viewable control. (Use the Tab Order
to pass the focus to the Text Box)
(I have stressed "Do Not set the Textbox to invisible" because it has to
accept focus and an invisible control cannot but a 0cm wide textbox can)
In the On Got Focus event of the Text box, pass focus back to the next
Control you wish to be used.
DoCmd.GotoControl "YourControlName"
(You will notice the textbox and it will not interupt you data entry because
as soon as it gets focus it passes it onto the next control in the sequence)
This will jump the form down to where you want it to be to allow more
information to be added. Repeat this for the next screen step you require.
This way the form will automatically shift down as Controls are filled in
and jump back up to the top of the screen as new records are added and the
first control once again gets the focus. All without having to use the scroll
bars.
I hope this is what your meant to do and I have explained this procedure
correctly?
Does this answer your question?
Kindest Regards
Mike B
control lower than the viewable screen gain focus????
However, perhaps you want to jump the screen down further than one control?
The way i would do this should I require it would be to place an unbound
TextBox on the form adjacent to the next control which is below the viewable
screen or to where you want the screen to shift to. Set the Label of the text
box to Invisible (Not the Text Box itself) and set the width of the text box
to zero width (Width = 0cm). (You now have a practically invisible Text Box
on your form). The text box has a tab stop, use that to give the text box
focus when you have filled in the bottom viewable control. (Use the Tab Order
to pass the focus to the Text Box)
(I have stressed "Do Not set the Textbox to invisible" because it has to
accept focus and an invisible control cannot but a 0cm wide textbox can)
In the On Got Focus event of the Text box, pass focus back to the next
Control you wish to be used.
DoCmd.GotoControl "YourControlName"
(You will notice the textbox and it will not interupt you data entry because
as soon as it gets focus it passes it onto the next control in the sequence)
This will jump the form down to where you want it to be to allow more
information to be added. Repeat this for the next screen step you require.
This way the form will automatically shift down as Controls are filled in
and jump back up to the top of the screen as new records are added and the
first control once again gets the focus. All without having to use the scroll
bars.
I hope this is what your meant to do and I have explained this procedure
correctly?
Does this answer your question?
Kindest Regards
Mike B
M
MikeJohnB
Correction:
Should read
(You will NOT notice the textbox and it will not interupt you data entry
because
as soon as it gets focus it passes it onto the next control in the sequence)
(You will notice the textbox and it will not interupt you data entry because
as soon as it gets focus it passes it onto the next control in the sequence)
Should read
(You will NOT notice the textbox and it will not interupt you data entry
because
as soon as it gets focus it passes it onto the next control in the sequence)
B
Byron
Thanks Mike
--
Byron Gomez
--
Byron Gomez
MikeJohnB said:Correction:
Should read
(You will NOT notice the textbox and it will not interupt you data entry
because
as soon as it gets focus it passes it onto the next control in the sequence)
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B
B
Byron
Mike,
I didn’t do a very good job of describing what I need to do. I
have a Form which has five Sub-Forms and I can’t get it to automatically
scroll once it gets to the end of the main Form. I tried to use (After Update
– Go to Control) when the Main Form gets to the last control on it but I get
an error message telling me there is no field named “******†in the current
record. For some reason Access doesn’t recognize the Sub-Forms as part of the
current record. I hope I have explained myself a little better this time
around.
I didn’t do a very good job of describing what I need to do. I
have a Form which has five Sub-Forms and I can’t get it to automatically
scroll once it gets to the end of the main Form. I tried to use (After Update
– Go to Control) when the Main Form gets to the last control on it but I get
an error message telling me there is no field named “******†in the current
record. For some reason Access doesn’t recognize the Sub-Forms as part of the
current record. I hope I have explained myself a little better this time
around.
M
MikeJohnB
Hi Byron
Sorry about misunderstanding your question.
You need to look at the following
Me.Parent.subform2.SetFocus
Me.Parent.subform2.Form.controlname2.SetFocus
As you prbably know, me. is a short version of using the Forms! collection.
However, another thought
When you set the main form in design view and select Tab Order. You will no
doubt set the controls to tab through in the order that you want.
In the tab order you will no doubt see the first subform which will have a
tab so you should be able to set that as the next tab order after the last
Control you want to take focus. In the tab order for the subform, you should
also see the tab for the next subform, set that after the last control in
that form.
I hope this helps a little and that you will look here again. Please post
back if you need more help?
Regards
Mike B
Sorry about misunderstanding your question.
You need to look at the following
Me.Parent.subform2.SetFocus
Me.Parent.subform2.Form.controlname2.SetFocus
As you prbably know, me. is a short version of using the Forms! collection.
However, another thought
When you set the main form in design view and select Tab Order. You will no
doubt set the controls to tab through in the order that you want.
In the tab order you will no doubt see the first subform which will have a
tab so you should be able to set that as the next tab order after the last
Control you want to take focus. In the tab order for the subform, you should
also see the tab for the next subform, set that after the last control in
that form.
I hope this helps a little and that you will look here again. Please post
back if you need more help?
Regards
Mike B
B
Byron
Mike,
I tried it and it worked. Thanks for your help, have a great weekend
I tried it and it worked. Thanks for your help, have a great weekend
M
MikeJohnB
You're welcome Byron, glad to be of assistance once we had narrowed down your
requirement, have a good weekend also and a beer on me
Cheers
requirement, have a good weekend also and a beer on me
Cheers
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.