I want to concat 2 Fields together and have a return between them

is field 1 & new line & field2

What is the correct format

Thanks

Try:
[FieldA] & Chr(13) & Chr(10) & [FieldB]

--
Duane Hookom
MS Access MVP


"Nigel" <(E-Mail Removed)> wrote in message
news:11D9EB96-3BBC-4029-8C07-(E-Mail Removed)...
>I want to concat 2 Fields together and have a return between them
>
> is field 1 & new line & field2
>
> What is the correct format
>
> Thanks

Put & vbCrLf & between the fields you are concatting.

--
hth,
SusanV

"Nigel" <(E-Mail Removed)> wrote in message
news:11D9EB96-3BBC-4029-8C07-(E-Mail Removed)...
>I want to concat 2 Fields together and have a return between them
>
> is field 1 & new line & field2
>
> What is the correct format
>
> Thanks

vbCrLf works well in code but not outside of code.

--
Duane Hookom
MS Access MVP


"SusanV" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Put & vbCrLf & between the fields you are concatting.
>
> --
> hth,
> SusanV
>
> "Nigel" <(E-Mail Removed)> wrote in message
> news:11D9EB96-3BBC-4029-8C07-(E-Mail Removed)...
>>I want to concat 2 Fields together and have a return between them
>>
>> is field 1 & new line & field2
>>
>> What is the correct format
>>
>> Thanks
>
>

Never occurred to me this was outside code...
Sorry for any confusion!

SusanV

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:OID1$(E-Mail Removed)...
> vbCrLf works well in code but not outside of code.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "SusanV" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Put & vbCrLf & between the fields you are concatting.
>>
>> --
>> hth,
>> SusanV
>>
>> "Nigel" <(E-Mail Removed)> wrote in message
>> news:11D9EB96-3BBC-4029-8C07-(E-Mail Removed)...
>>>I want to concat 2 Fields together and have a return between them
>>>
>>> is field 1 & new line & field2
>>>
>>> What is the correct format
>>>
>>> Thanks
>>
>>
>
>

This is a modules News Group so the question could have involved code. You
never know and when you think you know and make an assumption, you are often
wrong. 'been there many times.

--
Duane Hookom
MS Access MVP


"SusanV" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Never occurred to me this was outside code...
> Sorry for any confusion!
>
> SusanV
>
> "Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
> news:OID1$(E-Mail Removed)...
>> vbCrLf works well in code but not outside of code.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "SusanV" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Put & vbCrLf & between the fields you are concatting.
>>>
>>> --
>>> hth,
>>> SusanV
>>>
>>> "Nigel" <(E-Mail Removed)> wrote in message
>>> news:11D9EB96-3BBC-4029-8C07-(E-Mail Removed)...
>>>>I want to concat 2 Fields together and have a return between them
>>>>
>>>> is field 1 & new line & field2
>>>>
>>>> What is the correct format
>>>>
>>>> Thanks
>>>
>>>
>>
>>
>
>

Excellent point!

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:%(E-Mail Removed)...
> This is a modules News Group so the question could have involved code. You
> never know and when you think you know and make an assumption, you are
> often wrong. 'been there many times.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "SusanV" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Never occurred to me this was outside code...
>> Sorry for any confusion!
>>
>> SusanV
>>
>> "Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
>> news:OID1$(E-Mail Removed)...
>>> vbCrLf works well in code but not outside of code.
>>>
>>> --
>>> Duane Hookom
>>> MS Access MVP
>>>
>>>
>>> "SusanV" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Put & vbCrLf & between the fields you are concatting.
>>>>
>>>> --
>>>> hth,
>>>> SusanV
>>>>
>>>> "Nigel" <(E-Mail Removed)> wrote in message
>>>> news:11D9EB96-3BBC-4029-8C07-(E-Mail Removed)...
>>>>>I want to concat 2 Fields together and have a return between them
>>>>>
>>>>> is field 1 & new line & field2
>>>>>
>>>>> What is the correct format
>>>>>
>>>>> Thanks
>>>>
>>>>
>>>
>>>
>>
>>
>
>