hide text if field is null (1 Viewer)

[Akai90]

hai

this is my current code for report access

="RM " & Format([YURANPROG1];"Standard") & " " & [yrnsujek1] &""

output : RM 50.00 / subjek
yuranprog1 = 50.00
subjek = / subjek

how can i hide "RM" if yuranprog1 and yrnsujek1 is empty or null on report

thanks

 

[The_Doc_Man]

Remember that you can have Print and Format events for reports, and that the Print event ONLY fires if the report is in Print Preview mode.

You can, in the section that contains those controls, have something like:

IF NZ( yuranprog1, "" ) = "" AND NZ( yrnsujeck1, "" ) = "" THEN
    RM.Visible = FALSE
ELSE
    RM.Visible = TRUE
    RM = 50.00 / subjek
END IF

This assumes that both of those variables are STRINGS (Short or Long). If they are not, NZ is perhaps still usable but in a different format than presented here. For instance, if [yuranprog1] is actually numeric, then that would be NZ( yuranprog1, 0 ) = 0 rather than the text version. Also, if you have other things to do to RM when it is visible, they can also go in the ELSE branch of that IF statement.

 

[Josef P.]

Try this:

= Format([YURANPROG1], "\R\M #,##0.00") & (" " + [yrnsujek1])