Row height on continuous form

[vandenherik]

I use a continuous form to display the result of a query from an action tracking database. Some of the fields are descriptions and therefore large text boxes (max 255 characters). I have set the cangrow and canshrink properties of these fields to yes. However, when opening the form not all text is displayed. Can anybody help me out?

 

[John Big Booty]

From here;

These properties affect the display of form sections and controls only when the form is printed or previewed, not when the form is displayed in Form view, Datasheet view, or Design view.

So unless you are printing or previewing your form the Can Grow Property will have no effect

 

[vandenherik]

John,
Thanks for the quick reply. Any hints as to have all the text showing in form view? (Other than manually)
Dirk

 

[John Big Booty]

You could use a continuous form and place a text box on it large enough to display all the data held in your longest record.

 

[John Big Booty]

... however given that you are using data sheet view I guess that's not the answer your looking for.

 

[vandenherik]

John,
That is right, not what I was looking for. There must be a way of doing it.
Dirk

 

[RainLover]

Have you thought about a Pop Up Form.

You could float that over the top of the existing form.

 

[John Big Booty]

You could use the RowHeight property to set the rows so they are tall enough to show all data in your longest record.

However his will effect all the rows in form. Beyond that you could look at a FlexGrid.

 

[RainLover]

John,
That is right, not what I was looking for. There must be a way of doing it.
Dirk

There most likely is a solution. Perhaps dozens, but the solution must fit your requirements.

Do you have somethimg in mind.?

 

[John Big Booty]

Another option could be to have a Control Tip for the field instructing the user to open the native Zoom Box feature to view those fields.

 

[vandenherik]

John,
Thanks for yr help. I decided to use a report and make it look like the forms i use. Works ok so far.
Dirk