Print First Character of 30 Byte Field on Report

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
 
J

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
 
B

Brad

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Page numbering with Merged Document and IF statements 1
Is this possible? 0
Detail_Format works in Print Preview but Not When Printing 0
Access Reports without an Access Table – Is this possible? 8
SORT REPORT 0
Converting GPS coordinates to decimal in Report 0

Top