Hide a specific word from the report

[Matin_Murad]

I want to hide or delete the words [cartoon] and the word [set] with parentheses when opening the report and keep them in the table

Without using the query


name table :: sales

 

[jdraw]

I'm not sure of your context, but often, when you don't want something to show in a report(output) but you want it to stay in the underlying table, you omit that "something" from the report's record source. For example, exclude the term(s) from the query so they will not be present in the report.

 

[pbaldy]

Since you say you don't want to use the query, you could have a textbox on the report:

=Replace(FieldName, "Cartoon","")

 

[arnelgp]

see this demo.

 

[Matin_Murad]

see this demo.

Thank you teacher is the desired verb thank you

 

[arnelgp]

Thank you teacher is the desired verb thank you

you view the report in design view and see the ControlSource of the textbox.