By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,759 Members | 1,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,759 IT Pros & Developers. It's quick & easy.

AC2000 - hitting enter after zooming a memo field closes the zoom instead of creating a new line

P: n/a
I think that just about sums it up. Is there a fix/workaround for this?It's
quite annoying behaviour and not user-friendly.thanksMartin
Nov 12 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
That is the default action of the Zoom box. You won't be able to fix
it.

If you are using a Text Box & you want to be able to hit Enter w/o
moving to next field/record, you have to set the Text Box's "Enter Key
Behavior" (under the Properties dialog box Other tab) to "New Line in
Field."

If you are trying to put multiple lines in a Label's Caption property
you can type the text w/ CRs in an open Notepad (you don't have to
create/save a new file) and cut & paste the text into the Caption.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQJ5kPIechKqOuFEgEQKgiACfUrmf46p67g+vTlevtNxmPR W/NjwAn3VB
qOvkduRXe8M2YBOSWbRou6tM
=oCkq
-----END PGP SIGNATURE-----
Deano wrote:
I think that just about sums it up. Is there a fix/workaround for this?It's
quite annoying behaviour and not user-friendly.thanksMartin


Nov 12 '05 #2

P: n/a
MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
That is the default action of the Zoom box. You won't be able to fix
it.
Ah, that's a bit of a downer. I have a continuous form and each record has
a smallish textbox where the user can enter some notes. These notes could
be quite long hence the zoom box. I just realised that you have to type
continuously instead of being able to hit enter to get a carriage return.
Of course you can do this at any time if you stay in the textbox. I think
that's a bit silly to be honest and doesn't offer a very friendly interface.

If you are using a Text Box & you want to be able to hit Enter w/o
moving to next field/record, you have to set the Text Box's "Enter Key
Behavior" (under the Properties dialog box Other tab) to "New Line in
Field."


Yes I think I must have this set up ok for me to be able to hit enter and
generate a new line successfully.

Is there an alternative to zooming? Or would i have to code up a pop up
form for the user to use (which sounds like alot work to me...)

thanks for the reply.

Nov 12 '05 #3

P: n/a
On Sun, 9 May 2004 17:11:07 +0100, Deano wrote:
I think that just about sums it up. Is there a fix/workaround for this?It's
quite annoying behaviour and not user-friendly.thanksMartin


When you are in the Zoom Box, hit Ctrl + Enter for a new line within
the Zoom Box and it won't exit the Box.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #4

P: n/a
fredg wrote:
On Sun, 9 May 2004 17:11:07 +0100, Deano wrote:
I think that just about sums it up. Is there a fix/workaround for
this?It's quite annoying behaviour and not user-friendly.thanksMartin


When you are in the Zoom Box, hit Ctrl + Enter for a new line within
the Zoom Box and it won't exit the Box.


Cheers, that'll do!
Nov 12 '05 #5

P: n/a
Hi folks,

[Ctrl] + [Enter] also works for labels and memo fields...

Don

"fredg" <fg******@example.invalid> wrote in message
news:uo*****************************@40tude.net...
On Sun, 9 May 2004 17:11:07 +0100, Deano wrote:
I think that just about sums it up. Is there a fix/workaround for this?It's quite annoying behaviour and not user-friendly.thanksMartin


When you are in the Zoom Box, hit Ctrl + Enter for a new line within
the Zoom Box and it won't exit the Box.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 12 '05 #6

P: n/a
"Deano" <de*********@hotmail.com> wrote in
news:nI*******************@stones.force9.net:
MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
That is the default action of the Zoom box. You won't be able to
fix it.


Ah, that's a bit of a downer. I have a continuous form and each
record has a smallish textbox where the user can enter some notes.
These notes could be quite long hence the zoom box. I just
realised that you have to type continuously instead of being able
to hit enter to get a carriage return. Of course you can do this
at any time if you stay in the textbox. I think that's a bit
silly to be honest and doesn't offer a very friendly interface.

If you are using a Text Box & you want to be able to hit Enter
w/o moving to next field/record, you have to set the Text Box's
"Enter Key Behavior" (under the Properties dialog box Other tab)
to "New Line in Field."


Yes I think I must have this set up ok for me to be able to hit
enter and generate a new line successfully.

Is there an alternative to zooming? Or would i have to code up a
pop up form for the user to use (which sounds like alot work to
me...)


The ZoomBox is just a form in one of the wizard MDEs that ships with
Access.

You could replicate it yourself with a text box that has your
preferred enter key.

The way I'd do it is create the zoom form with an unbound text box
set to have your preferred Enter key behavior. Assume that you're
going to pass the form the data you want edited in the form's OnLoad
event. To do that, check if Me.Openargs = vbNullString or not. If it
doesn't, then put the value of Me.Openargs in the textbox on the
form. Then, for the form's CLOSE button, have it hide the form
instead of closing it. The way I handle this is that I make the
CANCEL button also hide the form, but it sets the form's .Tag
property to CANCEL. This leaves the form open after you're done with
it so that code that follows can process the values in the form.

Then, wrap that form in a function. I'd do it like this:

Public Sub MyZoom(ctl As Control)
DoCmd.OpenForm "dlgMyZoom", , , , , acDialog,ctl.Value
If Forms!dlgMyZoom.Tag <> "Cancel" Then
ctl = Forms!dlgMyZoom!txtMemo
End If
DoCmd.Close acForm, "dlgMyZoom"
End Sub

This would allow you to customize your zoom form to your heart's
content.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #7

P: n/a
I have found that if you add an AutoKeys macro, and add a Macro Name of +{F2},
this overrides the default Zoom behavior for Shift+F2. From there, you can
simply use the Screen methods to get the active control of the active form.
Add some error handling, so the form simply won't open when there's no current
form or current control, and I think that'll do it.

Using the AutoKeys is nice, in that you don't have to paste code into every
form, then maintain that code everywhere, and keep it in sync. My only worry
would be that I've seen ActiveForm fail, sometimes, but I've only seen that
symptom with shortcut menus, not with AutoKeys.

On Mon, 10 May 2004 18:06:50 GMT, "David W. Fenton"
<dX********@bway.net.invalid> wrote:
"Deano" <de*********@hotmail.com> wrote in
news:nI*******************@stones.force9.net:
MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
That is the default action of the Zoom box. You won't be able to
fix it.


Ah, that's a bit of a downer. I have a continuous form and each
record has a smallish textbox where the user can enter some notes.
These notes could be quite long hence the zoom box. I just
realised that you have to type continuously instead of being able
to hit enter to get a carriage return. Of course you can do this
at any time if you stay in the textbox. I think that's a bit
silly to be honest and doesn't offer a very friendly interface.

If you are using a Text Box & you want to be able to hit Enter
w/o moving to next field/record, you have to set the Text Box's
"Enter Key Behavior" (under the Properties dialog box Other tab)
to "New Line in Field."


Yes I think I must have this set up ok for me to be able to hit
enter and generate a new line successfully.

Is there an alternative to zooming? Or would i have to code up a
pop up form for the user to use (which sounds like alot work to
me...)


The ZoomBox is just a form in one of the wizard MDEs that ships with
Access.

You could replicate it yourself with a text box that has your
preferred enter key.

The way I'd do it is create the zoom form with an unbound text box
set to have your preferred Enter key behavior. Assume that you're
going to pass the form the data you want edited in the form's OnLoad
event. To do that, check if Me.Openargs = vbNullString or not. If it
doesn't, then put the value of Me.Openargs in the textbox on the
form. Then, for the form's CLOSE button, have it hide the form
instead of closing it. The way I handle this is that I make the
CANCEL button also hide the form, but it sets the form's .Tag
property to CANCEL. This leaves the form open after you're done with
it so that code that follows can process the values in the form.

Then, wrap that form in a function. I'd do it like this:

Public Sub MyZoom(ctl As Control)
DoCmd.OpenForm "dlgMyZoom", , , , , acDialog,ctl.Value
If Forms!dlgMyZoom.Tag <> "Cancel" Then
ctl = Forms!dlgMyZoom!txtMemo
End If
DoCmd.Close acForm, "dlgMyZoom"
End Sub

This would allow you to customize your zoom form to your heart's
content.


Nov 12 '05 #8

P: n/a
David W. Fenton wrote:
"Deano" <de*********@hotmail.com> wrote in
news:nI*******************@stones.force9.net:
MGFoster wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
That is the default action of the Zoom box. You won't be able to
fix it.


Ah, that's a bit of a downer. I have a continuous form and each
record has a smallish textbox where the user can enter some notes.
These notes could be quite long hence the zoom box. I just
realised that you have to type continuously instead of being able
to hit enter to get a carriage return. Of course you can do this
at any time if you stay in the textbox. I think that's a bit
silly to be honest and doesn't offer a very friendly interface.

If you are using a Text Box & you want to be able to hit Enter
w/o moving to next field/record, you have to set the Text Box's
"Enter Key Behavior" (under the Properties dialog box Other tab)
to "New Line in Field."


Yes I think I must have this set up ok for me to be able to hit
enter and generate a new line successfully.

Is there an alternative to zooming? Or would i have to code up a
pop up form for the user to use (which sounds like alot work to
me...)


The ZoomBox is just a form in one of the wizard MDEs that ships with
Access.

You could replicate it yourself with a text box that has your
preferred enter key.

The way I'd do it is create the zoom form with an unbound text box
set to have your preferred Enter key behavior. Assume that you're
going to pass the form the data you want edited in the form's OnLoad
event. To do that, check if Me.Openargs = vbNullString or not. If it
doesn't, then put the value of Me.Openargs in the textbox on the
form. Then, for the form's CLOSE button, have it hide the form
instead of closing it. The way I handle this is that I make the
CANCEL button also hide the form, but it sets the form's .Tag
property to CANCEL. This leaves the form open after you're done with
it so that code that follows can process the values in the form.

Then, wrap that form in a function. I'd do it like this:

Public Sub MyZoom(ctl As Control)
DoCmd.OpenForm "dlgMyZoom", , , , , acDialog,ctl.Value
If Forms!dlgMyZoom.Tag <> "Cancel" Then
ctl = Forms!dlgMyZoom!txtMemo
End If
DoCmd.Close acForm, "dlgMyZoom"
End Sub

This would allow you to customize your zoom form to your heart's
content.


Sorry for not replying sooner but i've just tried implementing this as I
suddenly realised this could be quite useful.
When I call the MyZoom function what exactly am I passing to it?

Presumably the name of the textbox control that the user is double-clicking
on?

cheers
Martin

Nov 12 '05 #9

P: n/a
"Deano" <de*********@hotmail.com> wrote in
news:L_*******************@stones.force9.net:
David W. Fenton wrote:

Then, wrap that form in a function. I'd do it like this:

Public Sub MyZoom(ctl As Control)
DoCmd.OpenForm "dlgMyZoom", , , , , acDialog,ctl.Value
If Forms!dlgMyZoom.Tag <> "Cancel" Then
ctl = Forms!dlgMyZoom!txtMemo
End If
DoCmd.Close acForm, "dlgMyZoom"
End Sub

This would allow you to customize your zoom form to your heart's
content.


Sorry for not replying sooner but i've just tried implementing
this as I suddenly realised this could be quite useful.
When I call the MyZoom function what exactly am I passing to it?

Presumably the name of the textbox control that the user is
double-clicking on?


No, you're passing a control reference (since the parameter is of
type Control).

Thus:

Call ZoomBox (Me!txtFieldToBeEdited)

But do look at what Steve Jorgensen posted in response to my
recommendation. I don't do things that way, but he does have a good
point.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #10

P: n/a
David W. Fenton wrote:
"Deano" <de*********@hotmail.com> wrote in
news:L_*******************@stones.force9.net:
David W. Fenton wrote:

Then, wrap that form in a function. I'd do it like this:

Public Sub MyZoom(ctl As Control)
DoCmd.OpenForm "dlgMyZoom", , , , , acDialog,ctl.Value
If Forms!dlgMyZoom.Tag <> "Cancel" Then
ctl = Forms!dlgMyZoom!txtMemo
End If
DoCmd.Close acForm, "dlgMyZoom"
End Sub

This would allow you to customize your zoom form to your heart's
content.


Sorry for not replying sooner but i've just tried implementing
this as I suddenly realised this could be quite useful.
When I call the MyZoom function what exactly am I passing to it?

Presumably the name of the textbox control that the user is
double-clicking on?


No, you're passing a control reference (since the parameter is of
type Control).

Thus:

Call ZoomBox (Me!txtFieldToBeEdited)

But do look at what Steve Jorgensen posted in response to my
recommendation. I don't do things that way, but he does have a good
point.


Cheers I will have a look but i have no idea what Autokeys is so some
research is warranted.
Nov 12 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.