S
srctr
I have a letter I am creating. I have something wrong and cannot figure it
out.
This gives me an #error
=CanShrinkLines(Trim((StrConv(+[Title],3)) & " " & StrConv([First Name],3) &
(StrConv(" "+[MI],3)) & " " & StrConv([Last Name],3) & (",
"+[Suffix])),StrConv([Address1],3),StrConv([Address2],3),Trim(StrConv([City],3) & ", " & [State] & " " & [ZipEC]))
This works
=CanShrinkLines(Trim(StrConv([First Name],3) & (StrConv(" "+[MI],3)) & " " &
StrConv([Last Name],3) & (",
"+[Suffix])),StrConv([Address1],3),StrConv([Address2],3),Trim(StrConv([City],3) & ", " & [State] & " " & [ZipEC]))
My envelope works great but I don't do the case conversion
=CanShrinkLines(Trim((+[Title]) & " " & [First Name] & (" "+[MI]) & " " &
[Last Name] & (", "+[Suffix])),[Address1],[Address2],Trim([City] & ", " &
[State] & " " & [ZipEC]))
But I need to include the Title if there is one and everything in the table
is uppercase so I need it to use the proper case.
I know that StrConv([FieldName],3) converts the case. I know if I put a +
before the field it is only included if it is not blank. I don't understand
what is wrong.
Help!!
out.
This gives me an #error
=CanShrinkLines(Trim((StrConv(+[Title],3)) & " " & StrConv([First Name],3) &
(StrConv(" "+[MI],3)) & " " & StrConv([Last Name],3) & (",
"+[Suffix])),StrConv([Address1],3),StrConv([Address2],3),Trim(StrConv([City],3) & ", " & [State] & " " & [ZipEC]))
This works
=CanShrinkLines(Trim(StrConv([First Name],3) & (StrConv(" "+[MI],3)) & " " &
StrConv([Last Name],3) & (",
"+[Suffix])),StrConv([Address1],3),StrConv([Address2],3),Trim(StrConv([City],3) & ", " & [State] & " " & [ZipEC]))
My envelope works great but I don't do the case conversion
=CanShrinkLines(Trim((+[Title]) & " " & [First Name] & (" "+[MI]) & " " &
[Last Name] & (", "+[Suffix])),[Address1],[Address2],Trim([City] & ", " &
[State] & " " & [ZipEC]))
But I need to include the Title if there is one and everything in the table
is uppercase so I need it to use the proper case.
I know that StrConv([FieldName],3) converts the case. I know if I put a +
before the field it is only included if it is not blank. I don't understand
what is wrong.
Help!!