stripping out fields 1

[nickbrookes]

i'm finally onto producing my reports, and i need to be able to show a text string with the first two characters (eg a letter and then one space) taken out.

For instance A Hat should then show as Hat with no leading A or space.

I know someone out there must be able to help me!

Cheers

Nick

 

[nickjar2]

Something like this should work:

Dim s As String

s = "a hat"

MsgBox Mid$(s, 3, Len(s) - 2)

Nick

 

[nickjar2]

Sorry, I should have been a little more specific.
In your query for the report add a new field and place Mid$(s, 3, Len(s) - 2), where s is the name of the field that u want the 1st 2 chars removed.
Then bind a field on your report to this new field.

Nick