Code Help 1

[ptrifile]

I am using the following code to autopopulate a word document. Everything works fine except there are times when not all of the fields are populated so i get an error "Invalid use of NULL". Can someone please show me how I can adjust the following code so that if a field is NULL or empty it will just skip it and go to the next one? Below is a sample of the code im using

        .ActiveDocument.Bookmarks("bfirst").Select
        .Selection.Text = (CStr(Forms!frm_quote!bfirst))
        .ActiveDocument.Bookmarks("blast").Select
        .Selection.Text = (CStr(Forms!frm_quote!blast))
        .ActiveDocument.Bookmarks("bcompany").Select
        .Selection.Text = (CStr(Forms!frm_quote!bcompany))
        .ActiveDocument.Bookmarks("baddress1").Select
        .Selection.Text = (CStr(Forms!frm_quote!baddress1))

Thank you in advance for any help!

Paul

 

[HarleyQuinn]

I'd have a look at the Nz() function.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[tigersbh]

This should be one way (I'll just use one block of your code as an example).

Change:

.ActiveDocument.Bookmarks("bfirst").Select
.Selection.Text = (CStr(Forms!frm_quote!bfirst))

to

if not isnull(Forms!frm_quote!bfirst) then
.ActiveDocument.Bookmarks("bfirst").Select
.Selection.Text = (CStr(Forms!frm_quote!bfirst))
end if

 

[ptrifile]

Thank you tigersbh !!! that worked perfectly!!!

 

[JoeAtWork]

Using HarleyQuinn's suggestion would have saved you adding extra lines of codes. But I guess if its too much trouble looking up the Nz() function in Help or Google...

 

[PHV]

Furthermore, why Select ?
.ActiveDocument.Bookmarks("bfirst").Text = Trim(Forms!frm_quote!bfirst & "")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886