data value split

http://www.google.com/accounts/VE?service=groups2&c=CNHcx6iS7qrZ0AEQsYSqltP04cOtAQ&hl=en
I have data like
Return|Item
Cancelled|Item [CFY]
Gifts
I would like to display
if data has | then display it in two text box
like Textbox1 Return
Textbox2 Item
if data does not have | then display the "field value" in
Textbox1 and
Textbox2 should be ""
any help would be nice
thanksThe instr, left, right, and iif functions should get you there.
one piece:
=left(field,instr("|")-1)
Mike G.
<aajay78@.hotmail.com> wrote in message
news:1190911497.216601.202900@.d55g2000hsg.googlegroups.com...
> http://www.google.com/accounts/VE?service=groups2&c=CNHcx6iS7qrZ0AEQsYSqltP04cOtAQ&hl=en
> I have data like
> Return|Item
> Cancelled|Item [CFY]
> Gifts
> I would like to display
> if data has | then display it in two text box
> like Textbox1 Return
> Textbox2 Item
> if data does not have | then display the "field value" in
> Textbox1 and
> Textbox2 should be ""
> any help would be nice
> thanks
>