Another report question

[dmaier]

Thanks for the help I got on the previous question. Your solutions worked well. I have another question I need some urgent help on. I have a value for a field that can be outputted as example 05_C06 or 05_C07, etc. depending upon the values for the field. I would like to output only the C06 or C07. Is there a way on a report to get rid of the first three characters?

Thanks again for all of your help.

 

[TheAceMan1]

How are ya dmaier . . .

[blue]   Right(Me!TextboxName,3)[/blue]

See Ya! . . . . . .

 

[dmaier]

Thanks but sometimes there are 3 and sometimes there are four characters...eg C061 so I need something that will get rid of the first three characters to the left somehow.

 

[RoyVidar]

If the placement of the underscore character may vary

[tt]mid$(me!txtBox, instr(me!txtBox, "_")+1)[/tt]

else, plain old

[tt]mid$(me!txtBox, 4)[/tt]

forum703 is the report forum, this is the forms forum ...

Roy-Vidar

 

[dmaier]

Roy

Thanks. sorry for the oversight in being in the wrong place. Your suggestion worked perfectly.