If the data type is numeric, there can't be entries with a space. Something is a bit off there. Anyway, you can check for empty, space or nulls in one go:
UPDATE tblSummerYouthGrid SET Monday=0
WHERE NOT ISNUMERIC(Monday)>0

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

You could also make the table's column not allow nulls at all. This makes the VB code check unnecessary because the application will just throw an error if anything but a number is being inputted into that column.

Featured Post

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…