Continuous forms - repeating data

[cdevine]

I have a continuous subform with a recordsource which contains three types of data fields. (text, date, value)
What I want to achieve is to display only one of these fields depending on a value from the record(D, T, V)
In the form current event I can hide all 3 then make the field I want visible. This however works for all the fields displayed on the subform!
ie if I click on a date field all fields turn into date fields ??
Is there a way to overcome this problem?

 

[Keith P]

One way that you may be able to achieve what I think you're wanting, is to use a Query as the recordsource and define a fourth field using IIF. You will also have to use the Format function to get the appropriate display, e.g.
Field1 is text
Field2 is date
Field3 is currency

in the query CommonField: Iif(Not isNull([Field1]),[Field1],Iif(Not isNull([Field2]),Format([Field2],"dd/mmm/yyyy"),Format([Field3],"£#")))