Append "*" to a field in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
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
Click to expand...
Click to expand...
 
Thank you very much gentlemen, that was it!

OfficeDev18 via AccessMonster.com said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top