Hi everyone. I was hoping someone could help me debug some #error messages I am getting, driving me mad!

The following test works fine and prints the address split with a dash;
[claddr3] & " - " & [claddr3]

But, this gives me errors but I dont know why!

=StrConv("test",3) - WORKS
=StrConv([claddr3], 3) - #Error

Do i have to check that [claddr3] is a string or convert it to one before modifying?

Are you using this code in text boxes on your report?

Could it be that there are null values in these fields?

If so, check for nulls and supply an alternate value if the field is null.


mmcdonal

Hi,

Thanks for the reply mmcdonal! I figured it out, the boxes were assigned wrongly so i remade dummy ones and used them (not quite sure how they were broke in the first place) and it is working now. Access feels very finicky though! Have ordered a book on it all as I am clearly out of my depth here despite writing a few word and outlook macros, this is just, well, a whole new ball game!

p.s. ordered Alison Balter's Mastering Microsoft® Office Access 2003, it looked like the best book which wouldnt waste 300 pages telling you how to import data from excel and all that pretty obvious stuff. If youve read the book and think i've made a helluva mistake please let me know!

Thankyou again! :D

No, Alison Balter is probably the best for this sort of thing. There are two volumes, desktop and enterprise. Both are very good starting points.

Access can be a bit dodgey, so you have to know your code and its quirks. FIXING Access Annoyances is a good one from O'Reilly. Pretty much all the Wrox books on Access are good, except the Access VBA references. You can get much better descriptions online at MSDN. The commentary in the book is extremely thin and not very helpful.

Don't forget to get some VBScript references too, since it works in the VBA environment, and can be used for some very powerful operations that VBA does not support, or does not support as well. The Microsoft Windows 2000 Scripting Guide, and Advanced VBScript books are the best.

HTH

mmcdonal

Thanks for the advice. I checked out that Fixing Access Annoyances book and it seems perfect. Shame it has a cover design that makes me want to avoid it and makes you think it is the kinda thing you'd give your mum.

Thanks again.