[AccessD] acCmdZoomBox issues

Edward Zuris edzedz at comcast.net
Tue Jun 22 12:17:19 CDT 2010


 Thanks Jim and Steve.

 I can try to teach the users to use the click
 the left mouse button.

 I don't suppose Access has some easy way of just
 forcing the click the left mouse button.

 Ed.
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Monday, June 21, 2010 3:00 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] acCmdZoomBox issues


Sorry, I fat fingered the first email... let me try it again.

What have done is put a small button next to the field.
On the click event of the button I put something like:
    Me.txtbox.SetFocus
    DoCmd.RunCommand acCmdZoomBox

It does open the zoom box but I instruct the users to click the left
mouse button and then usually the cursor is at the end of the box.

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward Zuris
Sent: Monday, June 21, 2010 3:12 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] acCmdZoomBox issues


 The reason for the zoom box is because
 there is limited form space.

 So I tried to teach the customer to use  Shift+F2, but they keep
forgetting how to
 launch it.   So, I could teach them to
 double or single click instead.

 I think the zoom box is a different object  than the text box.  Is
there like me.zoom,  etc ?

 Thanks.

 Edz. . . .


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Monday, June 21, 2010 12:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] acCmdZoomBox issues


I thought I did it the 2nd way years ago, but testing it this morning I
see it opens the Zoom box in a modal mode.

You might have to create a simple pop up form as suggested by Stuart.

You can use a bigger text box with larger font and force the entry at
the end of the existing text.

What is the reason for the Zoom box? Usually they should be used to
display more data than is allowed on the form or datasheet. If they are
allowed to edit/enter data, I'd force them to do it via a new pop up
form, emulating a zoom box.

D

On Sun, Jun 20, 2010 at 5:44 PM, Edward Zuris <edzedz at comcast.net>
wrote:
>
>  Thanks David
>
>  I have been playing with that
>  and it seems to have no effect.
>
>  - - - Example - - -
>
>    With Me.txtTaskDescriptionN
>            .SetFocus
>            .SelStart = Len(.Text) + 1
>    End With
>
>    DoCmd.RunCommand acCmdZoomBox
>
>  - - - Or - - -
>
>    DoCmd.RunCommand acCmdZoomBox
>
>    With Me.txtTaskDescriptionN
>            .SetFocus
>            .SelStart = Len(.Text) + 1
>    End With
>
>  - - - Or - - -
>
>    DoCmd.RunCommand acCmdZoomBox
>
>    With Me.txtTaskDescriptionN
>            .SetFocus
>            .SelStart = 10
>            .SelLength = 5
>    End With
>
>    DoEvents
>
>
>  - - - - Any more Ideas to Try ? - - - -
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David
> McAfee
> Sent: Sunday, June 20, 2010 6:28 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] acCmdZoomBox issues
>
>
> Look into SelStart and Len(MyTextBox.Text)+1
>
> Sent from my Droid phone.
>
> On Jun 20, 2010 4:47 PM, "Edward Zuris" <edzedz at comcast.net> wrote:
>
>
>
>  When using the (DoCmd.RunCommand acCmdZoomBox) to do
>
>  a shift+F2 zoom on a text box all text is selected.
>
>
>
>  So if a customer fat fingers something or wants to
>
>  add something starts typing, without clicking at the
>
>  bottom-end of the data, all the previous information
>
>  is erased.
>
>
>
>  Is there anyway to deselect the data appearing inside
>
>  the Zoom text box before the customer starts typing?
>
>
>
>  Thanks.
>
>
>
>  Sincerely,
>
>  Ed Zuris
>
>  <mailto:edzedz at comcast.net> edzedz at comcast.net
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list