I have data like Return|Item Can

[aajay]

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

 

[xlbo]

Use LEFT / RIGHT & INSTR to look for the | in the field and wrap in an IIF statement



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question