Variant array data to display in continuous form

[Guest]

Access 2003 with Windows-XP.

I can conceive of a somewhat convaluted route to get the data elements in a
varying length array to display in a continuous form. My concept (which I
think is not particularily elegant) loops through the array, and moves all
the data elements to a single field in a temporary table from which they are
read for the continuous form.

In my case the data elements are all dates, so they are all the same data
type, but I guess this would be somewhat normal if the end result is to
display the data in a single feild continuous form.

I'm thinking this must be a somewhat common objective, and there might be a
far better and slicker process to acheive the end result.

Anyone got one?

As always....many thanks

 

[Brendan Reynolds]

If this is a read-only list, you could use a list-box like so ...

Private Sub Command2_Click()

Dim varList As Variant
Dim varLoop As Variant
Dim strList As String

varList = Array("one", "two", "three")
For Each varLoop In varList
strList = strList & varLoop & ";"
Next varLoop
With Me.List0
.RowSourceType = "Value List"
.RowSource = strList
End With

End Sub

 

[Albert D.Kallal]

As mentioned, often in this case, you might want to use a multi-column
listbox.

Take a look at the following screen shots, and you can see that OFTEN a list
box, and a continues sub-form are interchangeable

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

So, you could use a listbox, and the call back function (outlined in the
help), and call back is also outlined here:

http://www.mvps.org/access/forms/frm0049.htm

Note also that you can bind a function to a column and that also will work
(you would need to pass the id of the current column to make this of any
use.

I have example of check boxes in a continues form, but the check boxes are
un-bound, and don't requite a field (most people said this could not be
done!!). Take a look at the multi-select example I posted here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html