Re: [MS_AccessPros] #Type! error on control for a report

 

That worked. the source of the report was table. I do not like that set up. so I created a query and added that as you said to the source

Thank You

 

Jim Wagner

---

On Friday, January 13, 2017 2:12 PM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

Bill,

Have you tried placing the concatenation in a calculated column in the report's record source:

To: [First Name] & " " & [Last Name] & ", " & [Dept #]

What is the data type of [Dept #]?

Duane Hookom

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, January 13, 2017 2:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] #Type! error on control for a report

 

txtTo

 

Jim Wagner

---

On Friday, January 13, 2017 1:13 PM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

Bill,

What is the name of the text box? I assume it's not the same as the name of one of the fields.

BTW: It looks a bit chilly back home.

Regards,

Duane Hookom

Vevey Switzerland

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, January 13, 2017 11:30 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] #Type! error on control for a report

 

Hello all,

We run a report once a year and we are at that point. But I am getting a #Type! error on the report. I am concatenating several field from the source.

I have checked the names and spelling

I have deleted the text box and re-added the expression

If I put just one field it works correctly but not if I add the other fields

something is causing it to error out.

Here is the expression

=[First Name] & " " & [Last Name] & ", " & [Dept #]

what seems to be the issue here?

Thank You So Much for the help.

Jim Wagner

__._,_.___

---

Posted by: Jim Wagner <luvmymelody@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___