is it possible to hide duplicate fields values on a continuous for

[Patrick]

is it possible to hide duplicate fields values on a continuous form (ie the
second and further instances that appear of this duplciated value int eh
continuous form).

the form is not enabled for editing or deleting or adding


pat

 

[Allen Browne]

No. You cannot hide a field on some rows of a continuous form, while leaving
it visible on others.

However, you can simulate it with Continuous Formatting. For example, use
white text on a white backgroud for the condition where you want it
"hidden."

 

[Dan]

Can you give an example of the expression you would use to determine if a row
is the same as the previous row?

 

[Allen Browne]

Yes, that's not easy: especially where the user may filter or sort the form
on a whim, so the 'previous' row is not necessarily the one before it in the
table.

If you can ignore those complications, you can use a function such as
ELookup() here:
http://allenbrowne.com/ser-42.html
to get the previous value. Add a text box with Control Source like this:
=ELookup("MyField", "MyTable", "[MyID] < " & Nz([MyID],0), "MyID
[DESC]")
where the form's source table is named MyTable, and it has fields:
- MyID the AutoNumber (primary key), and
- MyField the name of the field whose value you need.