Display multiple records horizontally on form

[goodguy]

I have a form with just two fields.
I want to display more than one record horizontally.
At the moment, the records are displayed vertically.
I can't find the multi-column option for Access forms.


Is there a way to do this?

[June7]

There is no 'multi-column' formatting for a form, that is a report setup. VBA code can arrange records to display across, but they would not be editable. http://allenbrowne.com/func-concat.html

[goodguy]

Thanks, June7. I do not need edit capability, just need to intercept the click and doubleclick events.

[goodguy]

I just checked the link you gave; it is not at all related to my problem as it concatenates fields of the same record. Whereas I am asking to 'display' more than one record horizontally on a form. Actually, the records on my form consist of a single picture field each. And I want them to display as many as can fit across the width of the form.

[June7]

You should review that link again. It is a method to concatenate data from many records, NOT the fields of same record. However, I have doubts it will serve your purpose with images. Not sure any technique will. Are you storing image or link in the field?

Here is example of how I rearrange data to run across http://forums.aspfree.com/microsoft-...ry-322123.html

[goodguy]

Thanks, June7, I reviewed the ConCatRelated function code, you are right.
And yes again, it will not serve my purpose. Even if it were another data type, all I want is to arrange the fields across the form width while leaving them as they are with all their functionality of event code, etc.

[June7]

You have to rearrange the data by query or VBA or some combination. That is presented in my example. Then bind form to the query or as in my example, a temp table. How many related records would be involved? I.e., how many 'columns' would result? My example has no limit.

[goodguy]

Thanks, June7. Since it will not achieve wat I want it to, I am shelving this.

[June7]

What did you mean by 'leaving them as they are with all their functionality of event code, etc'? Data does not have event code.

[goodguy]

I wanted to implement click funtionality into the image controls and if possible, drag and drop too.

[June7]

Click functionality is an event of objects and controls, not the data. With regular data this is possible with rearrangement. I have little experience with querying image data. Rearrange the data, bind field to an image control. What happens? I don't know when drag and drop is ever a functionality in Access.

[goodguy]

OK, issue shelved till further notice.