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

Welcome Guest ( Log In | Register )

> Empty Field That's Not Really Empty, Office 2003    
 
   
littlethief
post Mar 3 2012, 09:40 PM
Post #1

UtterAccess Member
Posts: 48
Hello -

I have a field that looks empty but it's not. If you use Len(), it has a value of 4. And I know it's not 4 spaces. Is there a way I can tell what type of character is in there so I can create another field to match up to it?

Thank you!!
Go to the top of the page
 
+

Posts in this topic
- littlethief   Empty Field That's Not Really Empty   Mar 3 2012, 09:40 PM
- - Doug Steele   Use the Asc to find out the Ascii value of each ch...   Mar 3 2012, 09:42 PM
- - littlethief   Thank you, Doug. I got the following result: 032...   Mar 3 2012, 10:07 PM
- - tina t   QUOTE QUOTE I have a field that looks empty but it...   Mar 3 2012, 11:16 PM
- - gemmathehusky   char 32 is a space, so the field does appear to co...   Mar 4 2012, 12:12 PM

« Next Oldest · Access Tables + Relationships · Next Newest »
 

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

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · 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 - 09:23 PM