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  

Stop form from closing when I press Enter



 
 
Thread Tools Display Modes
  #1  
Old December 8th, 2009, 09:35 PM posted to microsoft.public.access.forms
RebeccaKT
external usenet poster
 
Posts: 2
Default Stop form from closing when I press Enter

Every form I have closes automatically if I press enter.

From what I can tell - that's just how Access is set up. Is there a way to
change this setting? Or can I insert a Macro into the "On Close" Event on my
form that will give me the option to exit or continue?

HELP!
  #2  
Old December 8th, 2009, 09:46 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Stop form from closing when I press Enter

You did not say what version of Access you have. Access 2007 you click on
Office button, at bottom of pave select Access Options - Advanced - Editing
and then one of three choices - Don't move, Next field, Next record.

Earlier versions click on Tools - i think it was Options - Advanced - ...

--
Build a little, test a little.


"RebeccaKT" wrote:

Every form I have closes automatically if I press enter.

From what I can tell - that's just how Access is set up. Is there a way to
change this setting? Or can I insert a Macro into the "On Close" Event on my
form that will give me the option to exit or continue?

HELP!

  #3  
Old December 8th, 2009, 09:49 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Stop form from closing when I press Enter

There is no setting in Access to autoclose a form.My guess is that you have
a close button on your form that is closing the form. Try changing the Tab
stop property of the button from no to yes.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"RebeccaKT" wrote in message
...
Every form I have closes automatically if I press enter.

From what I can tell - that's just how Access is set up. Is there a way to
change this setting? Or can I insert a Macro into the "On Close" Event on
my
form that will give me the option to exit or continue?

HELP!



  #4  
Old December 8th, 2009, 09:57 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default Stop form from closing when I press Enter

"RebeccaKT" wrote in message
...
Every form I have closes automatically if I press enter.

From what I can tell - that's just how Access is set up. Is there a way to
change this setting? Or can I insert a Macro into the "On Close" Event on
my
form that will give me the option to exit or continue?



This is not normal Access behavior. You mean to say that every form
actually closes, and disappears from the screen, when you press Enter?

Do you by any change have a "close" button on your form, with its Default
property (on the Other tab of its property sheet) set to Yes?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

 




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 01:30 AM.


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