Concatenation of text field of table (size > 50 char)with other st

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

Guest

I have a problem in displaying data in a report
I have a field "PersonName" in a table that is of 70 chars. The default
value for text field is 50 chars.

I want to display the name as (Abdul Basit) in a text box in a report. so I
write the following code in the "Control Source" property of a text field

= "(" & [PersonName] &")"

When i run the query, it gives error, if I change the size of "PersonName"
field to default, it works fine

Please tell me wat i do to display the data like that



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a7f23ffe2f&dg=microsoft.public.access.reports
 
Abdul,

I can't see that the text field default is 50 can be a problem. You might
get a problem if the textbox name is also PersonName - did you create the
report initially using the wizard?

Your syntax looks fine; just check field spellings.
Try this:
Double-click on the text box
Click on the 'Other' tab, and
Change the name to something else, maybe txtFullName.

Double-check the data source of the report has a PersonName field in it.

Let me know...

Piers
 
Back
Top