Display Part Text In Report

  • Thread starter Thread starter zyus
  • Start date Start date
Z

zyus

I hv this sample report in my field

01-01-08ABCDE....................

I want to display ABCDE........and so on...and not the 01-01-08

What should i do...

Thanks
 
zyus,

Try this in the Control Source of a text box on your report:

=Mid([YourFieldName],9)

Caution: The text box name must be different than the field name. If they
are the same, change the text box name to txtYourFieldName.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005
Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
This email made with 100% recycled electrons!
Miscellaneous Access "stuff" at www.ScoBiz.com
 
You must log in or register to reply here.

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

Help with a Monthly Report Design and Layout 2
Concatenate work order #'s 3
Using DateAdd and IIF conditions in a Query 2
VERITICAL & HORIZONTAL REPORT 2
Update field 3
sum and insert into table? 5
Expression / SQL Statement Help 9
Date Range Query. Criteria based in a table. 4

Back
Top