How do I enlarge a field on a form for easier viewing or data entr

[Bob Waggoner]

I have a form with many fields on it (Management Review) where data is
entered. I'd like to enlarge the field if someone wants to enlarge it to view
or do data entry. The field, for example, is [ReviewPastNotes] in the form
[frmOPMItems].

I'd like to do this on a double-click event. Can anyone help with the code?
The current size of the field is 2" width and 1" height. I'd like to enlarge
it to 4" and 3". Right now, my code makes the field disappear! Help.

 

[fredg]

I have a form with many fields on it (Management Review) where data is
entered. I'd like to enlarge the field if someone wants to enlarge it to view
or do data entry. The field, for example, is [ReviewPastNotes] in the form
[frmOPMItems].

I'd like to do this on a double-click event. Can anyone help with the code?
The current size of the field is 2" width and 1" height. I'd like to enlarge
it to 4" and 3". Right now, my code makes the field disappear! Help.

What do you mean by "my code makes the field disappear!"?
What, exactly, is your code?
Are we to guess?

Try using the Zoom Box feature.
While the control has the focus, press <Shift> + F2
or..

Code the Control's Double-click event:
DoCmd.RunCommand acCmdZoomBox
or ..

Open a different form to enter or edit the data. The form must be
bound to the same table/query as the current form, and the control on
the form bound to the same field as the one on the current form. Size
the control as big as you wish.

DoCmd.OpenForm "frmSpecialEditing", , , "[ID] = " & Me.ID, , acDialog

The above form will open. Enter the new or corrected data. Close the
form and the new data will appear on the original form.

 

[Bob Waggoner]

Fred,
Thank you for your help on this. I didn't include my code because I didn't
think it would help. Here's what I had
me![fieldname].width = 4
me![fieldname].height = 3

I think the zoombox control on double click may work. I didn't realize the
runcommand had that.

Thanks again.
Bob

I have a form with many fields on it (Management Review) where data is
entered. I'd like to enlarge the field if someone wants to enlarge it to view
or do data entry. The field, for example, is [ReviewPastNotes] in the form
[frmOPMItems].

I'd like to do this on a double-click event. Can anyone help with the code?
The current size of the field is 2" width and 1" height. I'd like to enlarge
it to 4" and 3". Right now, my code makes the field disappear! Help.

What do you mean by "my code makes the field disappear!"?
What, exactly, is your code?
Are we to guess?

Try using the Zoom Box feature.
While the control has the focus, press <Shift> + F2
or..

Code the Control's Double-click event:
DoCmd.RunCommand acCmdZoomBox
or ..

Open a different form to enter or edit the data. The form must be
bound to the same table/query as the current form, and the control on
the form bound to the same field as the one on the current form. Size
the control as big as you wish.

DoCmd.OpenForm "frmSpecialEditing", , , "[ID] = " & Me.ID, , acDialog

The above form will open. Enter the new or corrected data. Close the
form and the new data will appear on the original form.

 

[John W. Vinson]

Fred,
Thank you for your help on this. I didn't include my code because I didn't
think it would help. Here's what I had
me![fieldname].width = 4
me![fieldname].height = 3

The reason your textbox is disappearing is that you're setting it to .0028" by
..0021". The unit of measure for the Width and Height properties is twips,
1/1440 of an inch.

 

[Larry Daugherty]

Probably the easiest way to achieve your desired result is to simply
open a new form in Dialog mode that displays just the field in
question and that has a command button to close the form. So a
doubleclick in the existing textbox will open the new form and closing
the new form returns you to the existing form.

FWIW the whole business of jerking your users around in that way isn't
particularly *friendly*. They somehow have to be educated to the fact
that a doubleclick will expand their view of that field. It would be
cumbersome if you were to do that for several textboxes on a form..
Really bad if you were doing it on several forms. IMHO it is much
better to organize your form around a single purpose and to design the
controls on the form for optimum usability for the user. Break up
complex tasks into smaller and more focused tasks. It you absolutely
must present large numbers of controls in a single part of the
workflow it would be better to use Page breaks or Tab controls
(better)

HTH

 

[Bob Waggoner]

Thank you, Larry.
This is part of our quality system. Its the management review section where
we get together once a quarter to look at all the aspects of our quality
program. By using the form instead of a report (such as the agenda), we can
input notes during the meeting instead of having to take notes and then enter
them into the database. Also, it gives us an opportunity to look at all parts
of the quality system without "leaving" the form. For example, we can double
click on the label that says Nonconformances and bring up a report that shows
current nonconformances in the system. Because of the amount of information
we need to cover, the fields are small. Using the zoom box will allow people
at the meeting to see the entire text field - and input notes without having
to scroll.

I like your idea of opening a new form by a double click event - that way I
wouldn't be limited to the zoom box font size and since people are together
in a conference room - the resolution on overhead screens/projectors is not
that good in some cases, it would allow larger type.

Question:
How do I get the current field to show up in a subform without creating a
subform for every field?

Probably the easiest way to achieve your desired result is to simply
open a new form in Dialog mode that displays just the field in
question and that has a command button to close the form. So a
doubleclick in the existing textbox will open the new form and closing
the new form returns you to the existing form.

FWIW the whole business of jerking your users around in that way isn't
particularly *friendly*. They somehow have to be educated to the fact
that a doubleclick will expand their view of that field. It would be
cumbersome if you were to do that for several textboxes on a form..
Really bad if you were doing it on several forms. IMHO it is much
better to organize your form around a single purpose and to design the
controls on the form for optimum usability for the user. Break up
complex tasks into smaller and more focused tasks. It you absolutely
must present large numbers of controls in a single part of the
workflow it would be better to use Page breaks or Tab controls
(better)

HTH
--
-Larry-
--

I have a form with many fields on it (Management Review) where data is
entered. I'd like to enlarge the field if someone wants to enlarge it to view
or do data entry. The field, for example, is [ReviewPastNotes] in the form
[frmOPMItems].

I'd like to do this on a double-click event. Can anyone help with the code?
The current size of the field is 2" width and 1" height. I'd like to enlarge
it to 4" and 3". Right now, my code makes the field disappear! Help.

 

[Larry Daugherty]

My response didn't propose a *subform* solution. It proposed a *new
form* in Dialog mode.

That's a simple solution for a simple problem. It can be replicated
for any number of controls on your form; each would require code in
its DoubleClick event and each would require a separate, simple, form.

It you want to be able to appropriately do the same kind of thing for
every control of every possible type on your original form without
creating separate forms then you have a much more complex set of
issues to overcome.

If it is at all suitable to your purposes, the free Magnifier from
Microsoft [in Accessories, Accessibility] is already on your system.

One excellent source of unique solutions regarding Access forms and
controls is Stephen Lebans at Lebans.com. Stephen's offerings have
all been free to date.

Another possible resource is Peter De Baets. He provides some unique
offerings (not free).

HTH
--
-Larry-
--

Thank you, Larry.
This is part of our quality system. Its the management review section where
we get together once a quarter to look at all the aspects of our quality
program. By using the form instead of a report (such as the agenda), we can
input notes during the meeting instead of having to take notes and then enter
them into the database. Also, it gives us an opportunity to look at all parts
of the quality system without "leaving" the form. For example, we can double
click on the label that says Nonconformances and bring up a report that shows
current nonconformances in the system. Because of the amount of information
we need to cover, the fields are small. Using the zoom box will allow people
at the meeting to see the entire text field - and input notes without having
to scroll.

I like your idea of opening a new form by a double click event - that way I
wouldn't be limited to the zoom box font size and since people are together
in a conference room - the resolution on overhead screens/projectors is not
that good in some cases, it would allow larger type.

Question:
How do I get the current field to show up in a subform without creating a
subform for every field?

Probably the easiest way to achieve your desired result is to simply
open a new form in Dialog mode that displays just the field in
question and that has a command button to close the form. So a
doubleclick in the existing textbox will open the new form and closing
the new form returns you to the existing form.

FWIW the whole business of jerking your users around in that way isn't
particularly *friendly*. They somehow have to be educated to the fact
that a doubleclick will expand their view of that field. It would be
cumbersome if you were to do that for several textboxes on a form..
Really bad if you were doing it on several forms. IMHO it is much
better to organize your form around a single purpose and to design the
controls on the form for optimum usability for the user. Break up
complex tasks into smaller and more focused tasks. It you absolutely
must present large numbers of controls in a single part of the
workflow it would be better to use Page breaks or Tab controls
(better)

HTH
--
-Larry-
--

I have a form with many fields on it (Management Review) where

data
is

entered. I'd like to enlarge the field if someone wants to

enlarge
it to view

or do data entry. The field, for example, is [ReviewPastNotes]

in
the form

[frmOPMItems].

I'd like to do this on a double-click event. Can anyone help

with
the code?

The current size of the field is 2" width and 1" height. I'd

like to
enlarge

it to 4" and 3". Right now, my code makes the field disappear!

Help.