View Single Post
  #3  
Old March 25th, 2009, 04: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