how to change the position of a field when printing depending on data 1

[laprog]

Hi everyone,

I need to pring a subtotal. I must print it in one of 2 available columns depending of data in the record.

Exemple: if CP = "C" then
1 2 3 4 5
| | | | | (print here) |
else
| | | |(print here)| |

which means i need to be able to change the position
of my field depending on the content of another field
in the record.

Thanks !

Sylvie

 

[dhookom]

Use code in the On Format event of the section containing the controls.
If Me.txtOtherTextBox > 10 Then
Me.txtTextBox.Left = 4000
Else
Me.txtTextBox.Left = 2000
End If
Substitute your control names and values. The other field MUST be bound to a control.

Duane
MS Access MVP