Print First Character of 30 Byte Field on Report

  • Thread starter Thread starter Brad
  • Start date Start date
B

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
 
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
 
John and Karl,

Thanks for the assistance, I appreciate it.

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

Thanks again,

Brad


KARL DEWEY said:
Did you try Left([YourField],1) ?

--
Build a little, test a little.


Brad said:
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
Click to expand...
Click to expand...
 
Back
Top