you need to edit the Spry Password settings.
In design View, select the password column, with the password column selected, a blue bounding box will appear around it, select the Blue bounding box to trigger the Spry Validation settings to appear in the property inspector, in the property inspector you can change the settings for maximum and minimum special to allow special characters.