conditional format one field to alter a second field (1 Viewer)

[John thomas]

Hi
Have a continuous form with 2 date fields in each record .
If dateField1 is empty ,Then I want a way to make DateField2 Take its Place .
I know how to make things happen with conditional formatting on one field by UsingIsNull ,
I have tried sending datefield2 to back.But cant work out how to bring it to front If DateField1 IsNull.
Many thanks

 

[JHB]

Sorry - I don't think you'll be able to do that in a continuous form, then you can't show one control in a record and then another control in the next record - it will always be the same for all records.

 

[John thomas]

Sorry Ive taken a while to get back .
Thanks for your help, I had a feeling that might be the case

 

[vbaInet]

You can do it in the Control Source of whichever textbox you choose to be the only date textbox, or do it in the record source (i.e. query) of the form:

Nz([[COLOR=Blue]Date1Field[/COLOR]], [[COLOR=Red]Date2Field[/COLOR]])