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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|