Group, I've got several textboxes within a form that are set to link to a data column that are set to accept a "null" (blank) value. However, these columns are formated to receive numeric data.
When the user bypasses entering anything within those textboxes (as they should do), what is the correct way to handle the reporting?
I've written it this way (I've not tested it yet) and am wondering if this is acceptable:
If txbSpecialCost.Text = "" Then Dim spclcost As String = "" Else Dim spclcost As Integer = Convert.ToInt32(txbSpecialCost.Text) End If
Hmmm.... This prompts a second question: Is there a way to determine if the characters within "txbSpecialCost" are Alph or Numeric characters? I'm thinking I need to add a message box to redirect them if they enter anything other than a numeric value.
Thanks for helping me with these two questions.