Hi all, I would like to format a column in datagrid with 2 conditions. The column must be entered with only "N/A" or date (DD-MMM-YYYY) format value.
If Me.grdDataGrid.DataFormats(10).Format <> "N/A" Then MsgBox "Invalid Data Entry!", vbInformation Exit Sub End If
The code above still produce "Invalid Data Entry" message though N/A is the input and I put this code under update function. How to include both conditions? Please help anyone.