show one data field in multiple columns on a form RRS feed

  • Question

  • I need to create a form that lists many items with an association check box (yes/no) field.  I would like to show the data across several columns on a form to maximize screen real estate.  Can this be done in MS Access?  Here is and example of how I would like the screen to look:

    Field 1      Field 2                  Field 1        Field 2                Field 1         Field 2

    Yes/No      Value 1                Yes/No       Value 2               Yes/No        Value 3

    Yes/No      Value 4                Yes/No       Value 5               Yes/No        Value 6

    Fields 1 and 2 are columns in a table.

    Thanks for any help you can give.

    Wednesday, July 18, 2018 8:49 PM

All replies

  • Hi John,

    If you don't need to edit the data, you can use a Report to display it like that. Otherwise, you may have to use a temp table and some code.

    Just my 2 cents...

    Wednesday, July 18, 2018 8:52 PM