Hide a specific word from the report (1 Viewer)

Matin_Murad

Member
Local time
Yesterday, 22:31
Joined
Jul 1, 2020
Messages
37
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
 

Attachments

  • subject.png
    subject.png
    8.7 KB · Views: 56
  • s.c.accdb
    640 KB · Views: 57

jdraw

Super Moderator
Staff member
Local time
Today, 01:31
Joined
Jan 23, 2006
Messages
15,364
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

Wino Moderator
Staff member
Local time
Yesterday, 22:31
Joined
Aug 30, 2003
Messages
36,118
Since you say you don't want to use the query, you could have a textbox on the report:

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

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 13:31
Joined
May 7, 2009
Messages
19,169
see this demo.
 

Attachments

  • sc_sample.accdb
    444 KB · Views: 70

Users who are viewing this thread

Top Bottom