How to hide leading characters in field within report

E

esupplystore

I have a field in a report and I want to hide the first 4 characters o
the field within the report. For example:

Qty SKU Description
1 w.2-Item A Item A 100p/case

should read:

Qty SKU Description
1 Item A Item A 100p/case

Note that the field SKU would hide the leading 4 characters of the SK
field when the report is generated/viewed, even though they are in th
data. Is there an easy way to do this from the report side? This woul
only apply to this one field of the report. The first character of th
4 can change from time to time between 2 different letters, but all
others stay the same.

If not, the report is based on a separate query...a way to do thi
within the query perhaps? (using Access 2000) Thanks! :
 
T

t t via AccessMonster.com

at design view of report;
1. set visibility of field SKU to NO
2. create new textbox delete it's label and put it over the SKU field
3. type control source of textbox =MID([SKU],5,LEN([SKU]))

so you will be able to hide first four characters of your field SKU.
 
R

Rick B

I would not do step 1, I'd just delete it and then do step 2 and 3.
Assuming [SKU] is a field name found in your report's data source, you will
be all set.
 
Top