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

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

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

-----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:
[color=blue]
> 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[/color]

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

MGFoster wrote:[color=blue]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> That is the default action of the Zoom box. You won't be able to fix
> it.[/color]

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.
[color=blue]
>
> 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."[/color]

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.

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

On Sun, 9 May 2004 17:11:07 +0100, Deano wrote:
[color=blue]
> 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[/color]

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.

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

fredg wrote:[color=blue]
> On Sun, 9 May 2004 17:11:07 +0100, Deano wrote:
>[color=green]
>> 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[/color]
>
> 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.[/color]

Cheers, that'll do!

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

Hi folks,

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

Don

"fredg" <fgutkind@example.invalid> wrote in message
news:uopkhn2ir9cf$.1atv8703fubpl.dlg@40tude.net...[color=blue]
> On Sun, 9 May 2004 17:11:07 +0100, Deano wrote:
>[color=green]
> > I think that just about sums it up. Is there a fix/workaround for[/color][/color]
this?It's[color=blue][color=green]
> > quite annoying behaviour and not user-friendly.thanksMartin[/color]
>
> 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.[/color]

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

"Deano" <deanma66999@hotmail.com> wrote in
news:nItnc.1971$NK4.166572@stones.force9.net:
[color=blue]
> MGFoster wrote:[color=green]
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>>
>> That is the default action of the Zoom box. You won't be able to
>> fix it.[/color]
>
> 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.
>[color=green]
>>
>> 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."[/color]
>
> 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...)[/color]

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

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

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"
<dXXXfenton@bway.net.invalid> wrote:
[color=blue]
>"Deano" <deanma66999@hotmail.com> wrote in
>news:nItnc.1971$NK4.166572@stones.force9.net:
>[color=green]
>> MGFoster wrote:[color=darkred]
>>> -----BEGIN PGP SIGNED MESSAGE-----
>>> Hash: SHA1
>>>
>>>
>>> That is the default action of the Zoom box. You won't be able to
>>> fix it.[/color]
>>
>> 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.
>>[color=darkred]
>>>
>>> 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."[/color]
>>
>> 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...)[/color]
>
>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.[/color]

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

David W. Fenton wrote:[color=blue]
> "Deano" <deanma66999@hotmail.com> wrote in
> news:nItnc.1971$NK4.166572@stones.force9.net:
>[color=green]
>> MGFoster wrote:[color=darkred]
>>> -----BEGIN PGP SIGNED MESSAGE-----
>>> Hash: SHA1
>>>
>>>
>>> That is the default action of the Zoom box. You won't be able to
>>> fix it.[/color]
>>
>> 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.
>>[color=darkred]
>>>
>>> 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."[/color]
>>
>> 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...)[/color]
>
> 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.[/color]

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

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

"Deano" <deanma66999@hotmail.com> wrote in
news:L_Roc.4017$NK4.337367@stones.force9.net:
[color=blue]
> David W. Fenton wrote:[/color]
[color=blue][color=green]
>> 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.[/color]
>
> 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?[/color]

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

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

David W. Fenton wrote:[color=blue]
> "Deano" <deanma66999@hotmail.com> wrote in
> news:L_Roc.4017$NK4.337367@stones.force9.net:
>[color=green]
>> David W. Fenton wrote:[/color]
>[color=green][color=darkred]
>>> 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.[/color]
>>
>> 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?[/color]
>
> 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.[/color]

Cheers I will have a look but i have no idea what Autokeys is so some
research is warranted.