My Assistant
Site Message
(Message will auto close in 2 seconds)
 Show first 20 characters of memo field in list box
|
|
 Jun 23 2006, 01:11 PM
Post
#1
|
|
|
UtterAccess VIP Posts: 1,447 From: New York City  |
I have a multi-column list box display and would like to show the first 20 characters of the contents of a memo field.
The SQL I created does pull the memo field when run in the Query area, but this memo field does not display when the SQL supports the list box. Any insight into this mystery? |
 |
 
|
 |
Replies
(1 - 5)
|
Jun 23 2006, 01:17 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 4,295 |
Karen
Why not use Left in the query? Only20:Left([YourMemoField], 20) As to the field not showing - have you checked the column count and widths? |
|
|
|
|
Jun 23 2006, 01:18 PM
Post
#3
|
|
|
UtterAccess VIP Posts: 1,447 From: New York City |
Ooops, I found it. I added this information to my column count, but forgot to change the count.
|
|
|
|
|
Jun 23 2006, 01:18 PM
Post
#4
|
|
|
VIP Emeritus Posts: 1,750 From: The Great White North |
Karen,
I was able to create a multi-column list box with the first 20 chars of a memo field being present using the LEFT SQL function. Can you go into a little more depth with your problem? Adam |
|
|
|
|
Jun 23 2006, 01:31 PM
Post
#5
|
|
|
UtterAccess VIP Posts: 1,447 From: New York City |
Adam, my swimming fish ... my problem was that I added a column to the list box, but forgot to change the number related to what can be displayed. Problem solved and the memo field works OK.
|
|
|
|
|
Jun 23 2006, 01:36 PM
Post
#6
|
|
|
VIP Emeritus Posts: 1,750 From: The Great White North |
Karen,
Excellent. And, to be honest, when I was trying to recreate your problem, I did the same thing (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif) Adam |
|
|
|
 |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 21st May 2013 - 05:23 PM |