[Programmer-VB] Update with Null

[Andhi Y]

Teman2,   Kenapa ya kalo saya mau update dan isinya akan null jika Text1 tidak mempunyai isi maka keluar pesan : “syntax error in UPDATE Statement”   Script yg saya jalankan: cn.Execute "Update MsBarang Set Harga=" & IIf(Text1.Text = "", Null, Text1.Text) & " Where Kode='01333'"   Bagaimana supaya nilainya itu adalah Null? databasenya adalah Access   Thanks B4     Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:     http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:     [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:     Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.