Solved

Access 2010 Len Function in query grid

Posted on 2013-05-21
2
611 Views
Last Modified: 2013-05-21
Hi Experts,

I utilize the Len function to count the number of characters in a datafield [H_SVP] which contains such data as A, BB, DDD, etc.  I use Len([H_SVP]) in a database which normally returns 1, 2, 3 respectively.

For some reason I return no results when I use the exact same field and len function in a different database....I don't get an error message just blank cells when I run the query.

I tried creating a new database and importing everything in case I had a bug but that didn't work either.

Any idea on why the Len function wouldn't work?
0
Comment
Question by:grmcra
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39185496
try doing this in the immediate window

?len("ABC")
3

did you get the correct result? No error?



* Open your references, from VBA window
Tools > References
check for any MISSING ref, uncheck and locate the available reference and select
click OK

in VBA window
do a debug >Compile
correct any error raised
0
 

Author Closing Comment

by:grmcra
ID: 39185541
...thank you, when I unchecked and then rechecked the references it worked.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question