Hiding repeating fields in a continuous form?

[tonygg]

Hi. I have a form generated from a query as a continuous form. It is basically showing a list of products and the section to which they belong (you can thing of 2 columns; Section Name and product name). It is ordered by section name. The results return and display correctly. However as there are many products in each section the field Section Name is shown for each product. Every product does belong to a section. Is there a way to use conditional formatting (or some other method) to only display the first occurrence of the section name for the products in that section. Something like:



Section 1 Product 1
Product 2
Product 3
Section 2 Product 4
Product 5
Section 3 Product 6


This makes the form easier to read and clearer where the sections change.

Many thanks

Tony

[Bob Fitz]

IMHO it would be better to use a report

[tonygg]

Thank you Bob. I am allowing the user to perform various activities on the data such as moving the products between sections (multiple products) and marking them for deletion (single products) so not sure a report would work well?

[ArviLaanemets]

I can't see a way to do this. A couple of possible workarounds:

a) You can consider a form-subform design instead. In main (unbound) form, you select a section. In subform, linked to section field in main form (or to unbound control in unbound main form where you select section), you display all products from this section;

b) (I can't check this as I haven't Access available at moment, so this will be a speculation.) When you have some numeric value (p.e. autonumber ID) for section, you can try to use conditional formatting to display rows for sections with even number one color, and with odd numbers another color (of-course when you have deleted some rows, the coloring will be messed up). The thing to check is, can you define a conditional formatting based on field value in row instead of control value (in continuous forms, the control value for all displayed rows is equal to control value in active row - so when you use conditional formatting based on control, all rows in form will be colored like active row).

[ssanfu]

Reports have the option for grouping - forms do not have that option. The closest solution would be a main form/sub form as Arvil suggested.

Main form detail section (in continuous forms mode) would be the Section; in the form footer would be the Product sub form (in continuous forms mode).
Access might complain about both forms being in continuous forms mode, but just change both back to continuous forms mode.
Set up the "Link Master Fields/ Link child Fields"........