formatting a continuous form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amanda Byrne - 10 May 2007 16:42 GMT

I have a "journal" continuous form that functions as a subform in my Animal
Record Entry (showing a diary of the animal's history). The journal subform
has a date, a journal type, and a note field.

I would like the note field to expand vertically in the continuous form as
needed when the note is long so that the whole note will be viewed. I played
with the "Auto-Resize" on the form and the "Can Grow" on the Note field, but
neither seems to help.

Any suggestions?

Thanks, Amanda

Amanda Byrne
IT Administrator
Carnivore Preservation Trust

Reply to this Message

Albert D. Kallal - 10 May 2007 20:54 GMT

The "can" grow options are only when you print the form.....

The size of the boxes are fixed. and, if via code you re-size one text box,
the will all reflect this box size.

So, what I do in those cases is make the box double wide. And then place a
button beside the box if the want a near full screen view/edit of the text
box.

There is a screen here that shows what I mean by placing a button beside the
text box:

http://www.kallal.ca/ridestutorialp/setdriver.htm
(look at the *last* screen shot).

Note the End of Tour bus notes box..it double high..and a button beside the
text box opens up a form in full screen mode to edit the text...

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

missinglinq - 11 May 2007 00:04 GMT

Another possibility is to expand the text box using the Zoom command. The
code below expands a text box when the the control has focus or when you
double-click the control.

Private Sub YourTextBox_GotFocus()
If Not IsNull(YourTextBox) Then
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

Private Sub YourTextBox_DblClick()
If Not IsNull(YourTextBox) Then
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

>The "can" grow options are only when you print the form.....
>
[quoted text clipped - 13 lines]
>Note the End of Tour bus notes box..it double high..and a button beside the
>text box opens up a form in full screen mode to edit the text...

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message