473,387 Members | 1,791 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

combining forename & surname in access report

I am trying to combine forename & surname in afield in access report but it gives error
Feb 27 '15 #1
2 1024
jforbes
1,107 Expert 1GB
Make sure the name of the TextBox that you are doing the concatenation in is different than any of the fields used on the Report.

If the TextBox's Name is "forename" and the ControlSource is
Expand|Select|Wrap|Line Numbers
  1. =[forename] & " " & [surname]
you will get an error in the field as Access will have trouble determining if forename is a reference to the control or a reference to a field in the RecordSource.
Feb 27 '15 #2
Rabbit
12,516 Expert Mod 8TB
If there are nulls in the data, you will need to handle them by converting nulls to a different value, like a blank string.
Feb 27 '15 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Nicola | last post by:
Hi Everyone, I am new to programming and would like to know how to open an access Report from within vb 6. I am trying to write a program to organise cross stitch threads. I have found out how...
0
by: Al | last post by:
Question #1 Can MS-Access Report be used with ASP? Question #2 Do the client needs to have MS-Office Installed in order to see MS-Report? Question #3 Do I need to Install MS_Office In ASP...
2
by: Vikrant | last post by:
Hey Friends I need to export an Access Report using a filter. I am using the method OutputTo m_pDoCmd->OutputTo( 3, // asOutputReport COleVariant(strReportName), // <report name>...
8
by: Mike MacSween | last post by:
tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At...
0
by: George | last post by:
I have a Microsoft Access report and I have automated this report using C#. When the report opens (via DoCmd.OpenReport) I am confronted with several prompts for criteria (example: "Please enter...
0
by: SMcK | last post by:
I have a PDA database program that allows me to use a bitmap image as a background for a drawing field. Users can draw digital ink on top of the bitmap and save the new ink as an OLE object in the...
0
by: Alexeye2008 | last post by:
Hi everyone! I am working on Access report from vb6 form. I want users to view only the running report. But if the user wants to do other jobs other than those related to the report, I want to exit...
6
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
0
by: ncsthbell | last post by:
I have a request to programatically create a .pdf file from within a current access application. The problem is that they want this one .pdf file to contain both an access report (created by the...
3
by: DeeJay Johnson | last post by:
Simple question - I need several Reports which are all very similar to each other. I have designed the first Report. Now I want to know how I can copy & paste the first Report so that I can generate...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.