property of a field

[gerard1979]

Using Access2002
This problem broke down my head, I hope somebody can help me.
I have a report. In the details_format I have the following easy function:
If Me.ArtNrFabr < 4000 Then
Me.lblNettoprijs.Caption = &quot;Normuur:&quot;
Else
Me.lblNettoprijs.Caption = &quot;Nettoprijs:&quot;
End If

When the lbl is &quot;Normuur:&quot; then the property of field Nettoprijs must be #,### (a double with 3 dec.)
When the lbl is &quot;Nettoprijs:&quot; the property must be a money notation

 

[AWithers]

You should be able to use something like this

If Me.ArtNrFabr < 4000 Then
Me.lblNettoprijs.Caption = &quot;Normuur:&quot;
Me.lblNettoprijs.Nettoprijs.Format = &quot;####.###&quot;
Else
Me.lblNettoprijs.Caption = &quot;Nettoprijs:&quot;
Me.lblNettoprijs.Nettoprijs.Format = &quot;Currency&quot;

End If

Andy