formatting a continuous form

[Guest]

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

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

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

Answers/posts based on Access 2000

Message posted via AccessMonster.com