Can Grow/Can Shrink - On Continuous Forms

[John Ortt]

Hi Everyone

I have a table called tblComments where I store details of any updates or
news relating to the database.

I would like to have a window on the front page which shows the coments (in
descending order).

My first solution to this was to create a continuous form and display this
in a subform on the main menu.

The problem was that the entries were all different sizes so there was lots
of wasted space and scrolling.

I am aware that Access does not allow the can grow/shrink functions to work
on continuous forms (other than print view)

but I think I have a workaround.... I just need help on how to do it.

My idea was to simply create a text box and then write the data into it
using code.

i.e. Sort table in descending order by dtmDateAdded.

For records (1 to 5)
write date
write return
write text
write return
Loop

Does anyone know the syntax for doing this please?

 

[Albert D.Kallal]

you can consider two sub-forms.

on the left, you place a continues form, and on the right side you have one
form with a large text box....

here is some ideas....

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

just use the on-current event of the left side to update the right side...

 

[John Ortt]

Thanks for the advice Albert, I'll have a look.