Append "*" to a field in a report?

[Brett D]

Hi I want to append a "*" to a certain field in my report. I've tried adding
"*" & to my Control Source but it says "Error" in the report.

Any suggestions?
Thanks very much,
bd

 

[Duane Hookom]

Did you change the name of the control so that it is not also the name of a
field?
What exact control source did you set?

 

[OfficeDev18 via AccessMonster.com]

Brett,

Since you want to modify the control source, you need to do two things. Let's
call the field 'Field1.'

1 - On the Control Source line of the Property Sheet, put

= [Field1] + "*"

2 - On the Name line, put, for example,

txtField1

In short, you cannot name the control Name or Control Source "Field1", since
you're actually modifying the field.

Hope this helps,

Sam

 

[OfficeDev18 via AccessMonster.com]

Duane,

Great minds think alike. I didn't see your post until after I hit 'Post.'

Sam

Brett,

Since you want to modify the control source, you need to do two things. Let's
call the field 'Field1.'

1 - On the Control Source line of the Property Sheet, put

= [Field1] + "*"

2 - On the Name line, put, for example,

txtField1

In short, you cannot name the control Name or Control Source "Field1", since
you're actually modifying the field.

Hope this helps,

Sam

Hi I want to append a "*" to a certain field in my report. I've tried adding
"*" & to my Control Source but it says "Error" in the report.

Any suggestions?
Thanks very much,
bd

 

[Brett D]

Thank you very much gentlemen, that was it!

Duane,

Great minds think alike. I didn't see your post until after I hit 'Post.'

Sam

Brett,

Since you want to modify the control source, you need to do two things. Let's
call the field 'Field1.'

1 - On the Control Source line of the Property Sheet, put

= [Field1] + "*"

2 - On the Name line, put, for example,

txtField1

In short, you cannot name the control Name or Control Source "Field1", since
you're actually modifying the field.

Hope this helps,

Sam

Hi I want to append a "*" to a certain field in my report. I've tried adding
"*" & to my Control Source but it says "Error" in the report.

Any suggestions?
Thanks very much,
bd