473,320 Members | 1,922 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,320 software developers and data experts.

Null Propagation Issue

Hi,

I am attempting to build a full name of a doctor using combo box
values, but all of the additional characters (commas, spaces, periods)
are returned.

Any help you can lend would be appreciated.

Henry
=====================

Here is the code:

strFullName = ((Me.cboAddPhysician.Column(10)) + " ") & _
((Me.cboAddPhysician.Column(11)) + ". ") & _
((Me.cboAddPhysician.Column(9) + " ")) & _
((", " + Me.cboAddPhysician.Column(12)) + ". ") & _
(Me.cboAddPhysician.Column(13))

(column map -> 10 is first name, 11 is middle, 9 is last name, 12 is
suffix, and 13 is degree.)

May 18 '06 #1
4 1682
The most glaring thing I see is the +'s should be &'s. You are
concantenating strings and need the &.

Henry Stockbridge wrote:
Hi,

I am attempting to build a full name of a doctor using combo box
values, but all of the additional characters (commas, spaces, periods)
are returned.

Any help you can lend would be appreciated.

Henry
=====================

Here is the code:

strFullName = ((Me.cboAddPhysician.Column(10)) + " ") & _
((Me.cboAddPhysician.Column(11)) + ". ") & _
((Me.cboAddPhysician.Column(9) + " ")) & _
((", " + Me.cboAddPhysician.Column(12)) + ". ") & _
(Me.cboAddPhysician.Column(13))

(column map -> 10 is first name, 11 is middle, 9 is last name, 12 is
suffix, and 13 is degree.)


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 18 '06 #2
"Henry Stockbridge" <hs***********@hotmail.com> wrote in
news:11**********************@y43g2000cwc.googlegr oups.com:
I am attempting to build a full name of a doctor using combo box
values, but all of the additional characters (commas, spaces,
periods) are returned.

Any help you can lend would be appreciated.

Henry
=====================

Here is the code:

strFullName = ((Me.cboAddPhysician.Column(10)) + " ") & _
((Me.cboAddPhysician.Column(11)) + ". ") & _
((Me.cboAddPhysician.Column(9) + " ")) & _
((", " + Me.cboAddPhysician.Column(12)) + ". ") & _
(Me.cboAddPhysician.Column(13))

(column map -> 10 is first name, 11 is middle, 9 is last name, 12
is suffix, and 13 is degree.)


Do Null columns in combo boxes return a Null or a zero-length
string?

This is the kind of thing I'd do in the combo box's rowsource, not
somewhere else. In that case, there's no question that the +
operator will propagate the Nulls.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 18 '06 #3
Thanks for the help. I found out the underlying tables allow zero
length strings, so I went the IIf route instead. :-(

May 19 '06 #4
"Henry Stockbridge" <hs***********@hotmail.com> wrote in
news:11*********************@y43g2000cwc.googlegro ups.com:
Thanks for the help. I found out the underlying tables allow zero
length strings, so I went the IIf route instead. :-(


I'd change the tables to disallow ZLS.

I've also written a ZLSToNull() function that I use for cases like
this where I can't get around dealing with ZLS's. It's pretty easy
to figure out how to do it, so I won't post the code.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 19 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: cliff | last post by:
My asp pages will not update rigth away on my Win2k3 server with IIS 6. I have found disabling lazy content propagation but it has not worked? Has anyone else had this problem?
3
by: A.M. de Jong | last post by:
Reading a lot about Nulls right now I still can't find a Technical reason to use it or not. For what I've understand is this: In an Ingres database a Null column has a standard extra storage...
6
by: Wendi | last post by:
If i have an iframe from within an HMTL document: Iframe.htm: ------------------------------ <html> <head> <title>Iframe.htm</title> </head> <body> <iframe src="sample.htm"></iframe>
39
by: ferrad | last post by:
I am trying to open a file for appending. ie. if the file exists, open it for appending, if not, create it. I am getting back a NULL pointer, and do not know why. Here is my code: FILE...
64
by: yossi.kreinin | last post by:
Hi! There is a system where 0x0 is a valid address, but 0xffffffff isn't. How can null pointers be treated by a compiler (besides the typical "solution" of still using 0x0 for "null")? -...
1
by: Henrik Dahl | last post by:
Hello! I'm trying to propagate a ContextMenu using a HierarchicalDataTemplate. The rendering looks just fine but how do I assign the Command property and CommandParameter property of the...
2
by: Weeble | last post by:
Back in C++, I had a type that looked something like this (entering from memory so this might not quite compile): template <class T> class NotNull { private: T* value; public: NotNull(T*...
3
ADezii
by: ADezii | last post by:
Null as it relates to database development is one of life's little mysteries and a topic of total confusion for novices who venture out into the database world. A Null Value is not zero (0), a zero...
22
by: ben mitch | last post by:
Hi I hope you'll see this cross-post (c/c++) as appropriate. I also admit immediately that the question *may* turn out to be compiler-/os-specific, in which case I apologize. But I wonder if...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.