Member Avatar for sanket044

i have binded one textbox at design time to adodc control...
and haveing one number field in database...
now problem is that, if their is a blank value in database adodc is showing 0 in that field..

can anyone help me, i want to show it as blank if it is,
what to do??? will DataFormat will help me???

  • 4 Contributors
  • 3 Replies
  • 95 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for ChrisPadgham

check to see if you have a default value specified, both for the textbox and for the field in the database

Member Avatar for poojavb

Since the datatype is number in ur access database the value returned to ur textbox will be 0...if u remove the default value for ur datatype number in the database it wont return any value...

Make it blank to get the text box value as blank

Member Avatar for AndreRet

OR,

just check the value and clear the textbox accorrdingly...

If Text1.Text = "0" Then
    Text1.Text = vbNullString ''CLear text - ""
End If
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.