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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old March 25th, 2009, 04:35 PM posted to microsoft.public.access.tablesdbdesign
Bob Waggoner[_2_]
external usenet poster
 
Posts: 80
Default How do I enlarge a field on a form for easier viewing or data entr

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.
  #2  
Old March 25th, 2009, 05:30 PM posted to microsoft.public.access.tablesdbdesign
fredg
external usenet poster
 
Posts: 4,386
Default How do I enlarge a field on a form for easier viewing or data entr

On Wed, 25 Mar 2009 08:35:01 -0700, Bob Waggoner wrote:

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #3  
Old March 25th, 2009, 05:40 PM posted to microsoft.public.access.tablesdbdesign
Bob Waggoner[_2_]
external usenet poster
 
Posts: 80
Default How do I enlarge a field on a form for easier viewing or data

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

"fredg" wrote:

On Wed, 25 Mar 2009 08:35:01 -0700, Bob Waggoner wrote:

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

  #4  
Old March 25th, 2009, 06:22 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default How do I enlarge a field on a form for easier viewing or data

On Wed, 25 Mar 2009 09:40:04 -0700, Bob Waggoner
wrote:

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.
--

John W. Vinson [MVP]
  #5  
Old March 25th, 2009, 06:41 PM posted to microsoft.public.access.tablesdbdesign
Larry Daugherty
external usenet poster
 
Posts: 1,012
Default How do I enlarge a field on a form for easier viewing or data entr

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-
--

"Bob Waggoner" wrote in
message news
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.



  #6  
Old March 25th, 2009, 07:08 PM posted to microsoft.public.access.tablesdbdesign
Bob Waggoner[_2_]
external usenet poster
 
Posts: 80
Default How do I enlarge a field on a form for easier viewing or data

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?

"Larry Daugherty" wrote:

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-
--

"Bob Waggoner" wrote in
message news
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.




  #7  
Old March 26th, 2009, 05:33 AM posted to microsoft.public.access.tablesdbdesign
Larry Daugherty
external usenet poster
 
Posts: 1,012
Default How do I enlarge a field on a form for easier viewing or data

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-
--

"Bob Waggoner" wrote in
message news
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?

"Larry Daugherty" wrote:

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-
--

"Bob Waggoner" wrote in
message news
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.





 




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 12:04 PM.


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