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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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."
 
Can you give an example of the expression you would use to determine if a row
is the same as the previous row?
 
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.
 
Back
Top