putting two fields together

[angie]

This works but if there is no entry the “TON” and “SEER” still shows, I do not wantanything to show if nothing is selected.


Thank you

Equiptment: [Proposals]![Ton] & " TON " &[Proposals]![Seer] & " SEER " & [Proposals]![Stage] &" " & [Proposals]![Type]

[ranman256]

in vbe (Alt-F11) , insert a new module, then paste this code,
then you can call it from a query, or form...
usage:

ConcatTon([ton],[seer],[stage],[type])

function ConcatTon(pvTon, pvSeer, pvStage, pvType)
dim vWord 

if not isNull(pvTon) then vWord = pvTon & " TON "
if not isNull(pvSeer) then vWord =vWord &  pvSeer & " SEER "
if not isNull(pvStage) then vWord =vWord &  pvStage & " "
if not isNull(pvType) then vWord =vWord &  pvType 

ConcatTon = vWord
end function

[June7]

An alternative is to use + instead of & to concatenate field with string. Concatenation using + with Null returns Null whereas concatenation with & returns the string.

Might want to correct the spelling of Equipment to remove the extra 't'.

Equiptment: [Proposals]![Ton] + " TON " & [Proposals]![Seer] + " SEER " & [Proposals]![Stage] + " " & [Proposals]![Type]

[angie]

An alternative is to use + instead of & to concatenate field with string. Concatenation using + with Null returns Null whereas concatenation with & returns the string.

Might want to correct the spelling of Equipment to remove the extra 't'.

Equiptment: [Proposals]![Ton] + " TON " & [Proposals]![Seer] + " SEER " & [Proposals]![Stage] + " " & [Proposals]![Type]

This worked great. Thank you June.