Code to make part of a table text field invisible in a report

[hunarch]

I have several identical text fields in a table. I want the same text to appear in reports, but I have ascertained that I need to make them unique in the tables. One way would be to add a unique suffix to each field. Is there code I can insert in the table text field that would make the suffixes invisible or truncated in reports?

Rod H.

 

[dhookom]

This is a very unusual request. I don't know why you would have "several identical text fields in a table" or why you would need to add a suffix or why you would then want to hide the suffix. You can display parts of a string value using functions like:
Left()
Right()
Mid()
...others...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[hunarch]

Thanks Duane.

I've found an effective, although not a programmatically elegant, improvisation by inserting ALT 255 at the end of the text (an invisible ASCII character).
Rod H.