formatting a continuous form

[Amanda Byrne]

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

 

[Albert D. Kallal]

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

 

[missinglinq via AccessMonster.com]

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