Print First Character of 30 Byte Field on Report

[Brad]

We have an Access 2007 Report that current pulls many fields from a database
table.

We need to add one additional field to this report, but we only want to
print the first byte of this new field.

Is this possible?

Thanks,

Brad

 

[John Spencer]

You can use an expression as the control's control source
=Left([SomeField],1)
Make sure there is no control in the report that has the same name as the name
of the field.


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[KARL DEWEY]

Did you try Left([YourField],1) ?

 

[Brad]

John and Karl,

Thanks for the assistance, I appreciate it.

=Left([Web_Order_Account_Rep],1) works nicely!

Thanks again,

Brad

Did you try Left([YourField],1) ?

--
Build a little, test a little.

We have an Access 2007 Report that current pulls many fields from a database
table.

We need to add one additional field to this report, but we only want to
print the first byte of this new field.

Is this possible?

Thanks,

Brad