new line in unbound box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Database User - 08 Jan 2006 11:29 GMT

Hi is there a way that i can have an 2 separate iif formulas in an unbound
box and i want the second one to begin on a new line.

is there any coding that i can stick between the 2 to do this

Thanks a lot

Reply to this Message

Duane Hookom - 08 Jan 2006 15:35 GMT

Too vague. Can you provide any information regarding your IIf() formulas,
data, and desired display?

Signature

Duane Hookom
MS Access MVP
--

> Hi is there a way that i can have an 2 separate iif formulas in an unbound
> box and i want the second one to begin on a new line.
>
> is there any coding that i can stick between the 2 to do this
>
> Thanks a lot

Reply to this Message

Database User - 09 Jan 2006 08:01 GMT

Its very simple basically i want the field in form view to look like this

Susan Atkinson (Wilson)
Susie Atkinson

it doesnt even have to be if formulas, the code could just be =[Name] & " "
& [Married Surname] then on the next line but i want it to be in the same
unbound box = [Nick Name]

> Too vague. Can you provide any information regarding your IIf() formulas,
> data, and desired display?
[quoted text clipped - 5 lines]
> >
> > Thanks a lot

Reply to this Message

Duane Hookom - 09 Jan 2006 14:58 GMT

If I understand correctly, you can use something like:
=[FieldA] & Chr(13) & Chr(10) & [FieldB]

Signature

Duane Hookom
MS Access MVP
--

> Its very simple basically i want the field in form view to look like this
>
[quoted text clipped - 16 lines]
>> >
>> > Thanks a lot

Reply to this Message