UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> How do you format a single column out of many columns in a list    
 
   
LittleViews
post May 3 2005, 09:39 AM
Post #1

UtterAccess VIP
Posts: 1,447
From: New York City
How do you format a single column in a list box?

I have a column that shows a number (an account ID). This is a new feature, so consequently, some accounts have no number, while others have one.

I'd like to substitue "NA" whenever an account ID is not present.
Go to the top of the page
 
+
Nwulf
post May 3 2005, 09:45 AM
Post #2

UtterAccess Guru
Posts: 814
From: MN
iif([AccountID] & "" = "", "NA", cstr([AccountID]))

That should do it.

Nick
Go to the top of the page
 
+
LittleViews
post May 3 2005, 10:14 AM
Post #3

UtterAccess VIP
Posts: 1,447
From: New York City
Cookie, can you tell me where that line belongs?

Does it follow after I submit the rowsource?

You know, me.myList.rowsource = "fancySQL"

Then where does that line go?
Go to the top of the page
 
+
Nwulf
post May 3 2005, 10:28 AM
Post #4

UtterAccess Guru
Posts: 814
From: MN
Take a look at the attached db.

HTH o!

Nick
Go to the top of the page
 
+
LittleViews
post May 3 2005, 10:30 AM
Post #5

UtterAccess VIP
Posts: 1,447
From: New York City
ThankX
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 12:47 PM