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.) 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
"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/
Thanks for the help. I found out the underlying tables allow zero
length strings, so I went the IIf route instead. :-(
"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/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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?
|
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...
|
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>
|
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...
|
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")?
-...
|
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...
|
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*...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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
|
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...
| |