Change number to text in report (1 Viewer)

S

sour

Registered User.

Local time

Today, 04:00

Joined

Oct 26, 2018

Messages

21

• Feb 13, 2019

• #1

I have a report that has week numbers within each week are cranes that have a delivery date, I have identified that all cranes go into storage has a week "0"
Within the report I want to replace the "0" with some text "STORE", I have tried VBA using an if statement, conditioning format just cant get it to work, the "0" is a number field, any ideas.

 

June7

AWF VIP

Local time

Today, 03:00

Joined

Mar 9, 2014

Messages

5,463

• Feb 13, 2019

• #2

Can have expression in query or textbox ControlSource.

=IIf([fieldname]=0, "STORE", [fieldname])

 

S

sour

Registered User.

Local time

Today, 04:00

Joined

Oct 26, 2018

Messages

21

• Feb 13, 2019

• #3

Ok I have just tried it but get a syntax error, I have tried it by adding the result to a text box as below

Private Sub Report_Open(Cancel As Integer)
=IIf([WK]=0, "STORE", [TEXT168])
End If
End Sub

 

S

sour

Registered User.

Local time

Today, 04:00

Joined

Oct 26, 2018

Messages

21

• Feb 13, 2019

• #4

Sorry forgot to put thanks for your help

 

S

sour

Registered User.

Local time

Today, 04:00

Joined

Oct 26, 2018

Messages

21

• Feb 13, 2019

• #5

O just tried it in the query worked first time thank you very much.

 

June7

AWF VIP

Local time

Today, 03:00

Joined

Mar 9, 2014

Messages

5,463

• Feb 13, 2019

• #6

The VBA you attempted is invalid structure, totally nonsense. VBA would not be best approach anyway.

Glad you got it resolved.