I have tried to make the value of Real Name and location NOT NULL.

When a new user first logs on I have made it so he goes to PROFILE and want him/her to add their name and location. However, when setting these fields to NOT NULL even if they are blank when they exit the Basic Profile page with the two fields blank the entry is still accepted.

Will what I want work ? I have rebuilt the tables and resynced btw.

Wayne