appending prefix to a report field

[Zenon]

I am attempting to append a string prefix to a report field which is
based on a query result. I want the user to be able click a checkbox
on the form which opens the report to determine whether the string is
appended or not. I see that this can be done in the properties of the
field, but I cannot figure out if it can be done with VB code. Since
it needs to be an option, I cannot do it in the properties (at least
as far as I know). Is this possible and if so, how is it done?
Thanks in advance.

[Allen Browne]

Set the Control Source of the text box on your report to something like
this:
=IIf([Forms].[Form1].[Checkbox1]=True, "My prefix ", Null) & [Field2])

Note that you should also change the Name property of the text box. If it
has the same name as the Field but is bound to something else, Access gets
confused.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Zenon" <ze****@comcast.net> wrote in message
news:b1**************************@posting.google.c om...

I am attempting to append a string prefix to a report field which is
based on a query result. I want the user to be able click a checkbox
on the form which opens the report to determine whether the string is
appended or not. I see that this can be done in the properties of the
field, but I cannot figure out if it can be done with VB code. Since
it needs to be an option, I cannot do it in the properties (at least
as far as I know). Is this possible and if so, how is it done?
Thanks in advance.

[Zenon]

Thanks for the help, however, I still can't get this to work. In my
test case, I have a form cleverly called TestForm. On it is a
checkbox called Check6, and a button which opens a report called
ReportTest based on a query called Query1. I have renamed Field1 on
the report to FieldOneName, and have entered the following formula in
it's control source. At this time, I'm not even worried about adding
the prefix but just getting the IIf statement to work. Do you see
what I'm doing wrong?

=IIf([Forms]![TestForm]![Check6]=True,([FieldOneName]="Checked"),([FieldOneName]="Not
Checked"))

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...

Set the Control Source of the text box on your report to something like
this:
=IIf([Forms].[Form1].[Checkbox1]=True, "My prefix ", Null) & [Field2])

Note that you should also change the Name property of the text box. If it
has the same name as the Field but is bound to something else, Access gets
confused.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Zenon" <ze****@comcast.net> wrote in message
news:b1**************************@posting.google.c om...

I am attempting to append a string prefix to a report field which is
based on a query result. I want the user to be able click a checkbox
on the form which opens the report to determine whether the string is
appended or not. I see that this can be done in the properties of the
field, but I cannot figure out if it can be done with VB code. Since
it needs to be an option, I cannot do it in the properties (at least
as far as I know). Is this possible and if so, how is it done?
Thanks in advance.

[Allen Browne]

Try:
=IIf([Forms]![TestForm]![Check6]=True,"Checked","Not Checked")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Zenon" <ze****@comcast.net> wrote in message
news:b1**************************@posting.google.c om...

Thanks for the help, however, I still can't get this to work. In my
test case, I have a form cleverly called TestForm. On it is a
checkbox called Check6, and a button which opens a report called
ReportTest based on a query called Query1. I have renamed Field1 on
the report to FieldOneName, and have entered the following formula in
it's control source. At this time, I'm not even worried about adding
the prefix but just getting the IIf statement to work. Do you see
what I'm doing wrong?

=IIf([Forms]![TestForm]![Check6]=True,([FieldOneName]="Checked"),([FieldOneN
ame]="Not Checked"))

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message

news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...

Set the Control Source of the text box on your report to something like
this:
=IIf([Forms].[Form1].[Checkbox1]=True, "My prefix ", Null) & [Field2])
Note that you should also change the Name property of the text box. If it has the same name as the Field but is bound to something else, Access gets confused.
"Zenon" <ze****@comcast.net> wrote in message
news:b1**************************@posting.google.c om...

I am attempting to append a string prefix to a report field which is
based on a query result. I want the user to be able click a checkbox
on the form which opens the report to determine whether the string is
appended or not. I see that this can be done in the properties of the
field, but I cannot figure out if it can be done with VB code. Since
it needs to be an option, I cannot do it in the properties (at least
as far as I know). Is this possible and if so, how is it done?
Thanks in advance.

[Zenon]

Beautiful, thanks very much. This expression worked perfectly.

=IIf([Forms]![TestForm]![Check6]=True,"Checked " & [Field1],"Not Checked")

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...

Try:
=IIf([Forms]![TestForm]![Check6]=True,"Checked","Not Checked")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Zenon" <ze****@comcast.net> wrote in message
news:b1**************************@posting.google.c om...

Thanks for the help, however, I still can't get this to work. In my
test case, I have a form cleverly called TestForm. On it is a
checkbox called Check6, and a button which opens a report called
ReportTest based on a query called Query1. I have renamed Field1 on
the report to FieldOneName, and have entered the following formula in
it's control source. At this time, I'm not even worried about adding
the prefix but just getting the IIf statement to work. Do you see
what I'm doing wrong?

=IIf([Forms]![TestForm]![Check6]=True,([FieldOneName]="Checked"),([FieldOneN
ame]="Not

Checked"))

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message

news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...

Set the Control Source of the text box on your report to something like
this:
=IIf([Forms].[Form1].[Checkbox1]=True, "My prefix ", Null) & [Field2])
Note that you should also change the Name property of the text box. If it has the same name as the Field but is bound to something else, Access gets confused.
"Zenon" <ze****@comcast.net> wrote in message
news:b1**************************@posting.google.c om...
> I am attempting to append a string prefix to a report field which is
> based on a query result. I want the user to be able click a checkbox
> on the form which opens the report to determine whether the string is
> appended or not. I see that this can be done in the properties of the
> field, but I cannot figure out if it can be done with VB code. Since
> it needs to be an option, I cannot do it in the properties (at least
> as far as I know). Is this possible and if so, how is it done?
> Thanks in advance.