Type and Num

[davies107]

Hello Everyone,

i have a problem regarding some of the boxes of records in my database. i have a command in every box of my DBS:

=CLng([SearchResults].[column](33))

my DBS has lots of records, some box have entries some do not have. so my problem is that if the box has no record it will show like this:

#Type! OR #Num!

is there a command that i should put that whenever an item/box has no entry it will appear blank?


picture is attached...

Thanks...

 

[pr2-eugin]

Lookup on the functionality of Nz()

 

[davies107]

Lookup on the functionality of Nz()

but how can i incorporate this one to my command:

=CLng([SearchResults].[column](33))

 

[pr2-eugin]

=CLng(Nz([SearchResults].[column](33),0))

Your Column count worries me..

 

[davies107]

ohhhhh, why? please let me know... im new to Access. your ideas or knowledge is highly appreciated. Thanks a lot.

 

[pr2-eugin]

Well I am not sure what the SearchResult is, but a wild guess would be ComboBox or Listbox and either of the two with a very large column will lead to confusion.. What is that you are doing here.. Could you explain a bit further?

BTW did it work?

 

[davies107]

im sorry but its not working...

actually, i use John Big Booty's sample :

http://www.access-programmers.co.uk/forums/showthread.php?t=188663

almost everything is similar to him...


im working on every boxes of my DBS (design view) with =CLng([SearchResults].[column](33))

some entries have no records to show, then it appears an error or something in the box (in form view already) #Type! OR #Num! , just like the attached photo.

what i want is that if it has no records to show, it will just appear blank, no #Type! OR #Num! or any characters that will appear.


but, somehow, i discovered that not only without records those errors appear but also to some boxes with records though not all.

i hope im clear because im not good in explaining since English is not my first language. i hope you understand. thanks.