Solved

Access 2010 Len Function in query grid

Posted on 2013-05-21
2
601 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 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
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
Comment Utility
...thank you, when I unchecked and then rechecked the references it worked.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now