control source

[Guest]

This is my control source for a text box on a form. Could you please tell me
how to add a title for each item?
=IIf([PV_NUMBER] Is Null,Null,Trim([PV_NUMBER] & ", " & [PV_GROUPNO] & " "
& [PV_GROUPNAME]))

Thanks

 

[Steve Schapel]

Dan,

Could you please give some more specific details, with examples? In
particular, what you mean by "add a title"? Thanks.

 

[Guest]

The code below produces the data for PV_NUMBER, PV_GROUPNO, PV_GROUPNAME I
need to add some kind of title, for example:

=IIf([PV_NUMBER] Is Null,Null,Trim([PV_NUMBER] ("PROVIDER NUMBER:")& ", " &
[PV_GROUPNO] ("GROUP NUMBER:") & " "

& [PV_GROUPNAME] ("GROUP NAME:")))

Expected results would be something like:
PROVIDER NUMBER: 123
GROUP NUMBER: 4567
GROUP NAME: MICROSOFT


Thanks

Dan,

Could you please give some more specific details, with examples? In
particular, what you mean by "add a title"? Thanks.

--
Steve Schapel, Microsoft Access MVP

This is my control source for a text box on a form. Could you please tell me
how to add a title for each item?
=IIf([PV_NUMBER] Is Null,Null,Trim([PV_NUMBER] & ", " & [PV_GROUPNO] & " "
& [PV_GROUPNAME]))

Thanks

 

[Steve Schapel]

Dan,

Thanks for the further clarification. I would do it like this...

=IIf(IsNull(PV_NUMBER]),Null,"Provider Number: " & [PV_NUMBER] &
Chr(13) & Chr(10) & "Group Number: " & [PV_GROUPNO] & Chr(13) & Chr(10)
& "Group Name: " & [PV_GROUPNAME])

--
Steve Schapel, Microsoft Access MVP

The code below produces the data for PV_NUMBER, PV_GROUPNO, PV_GROUPNAME I
need to add some kind of title, for example:

=IIf([PV_NUMBER] Is Null,Null,Trim([PV_NUMBER] ("PROVIDER NUMBER:")& ", " &
[PV_GROUPNO] ("GROUP NUMBER:") & " "

& [PV_GROUPNAME] ("GROUP NAME:")))

Expected results would be something like:
PROVIDER NUMBER: 123
GROUP NUMBER: 4567
GROUP NAME: MICROSOFT