Display Part Text In Report

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
 
M

M.L. Sco Scofield

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
 
Top