Try trimimg the field name/variable: If Trim(strLoginAmount) = "" Then Or If Len(Trim(strLoginAmount)) = 0 Then If neither work, response.write your values to the browser to see what they hold. Mark
[EMAIL PROTECTED] wrote: I have a field name LoginAmount that is empty in my access DB as I added it way after I have 1600 plus members. I have a code block now to test if it is emplty and if it is then it will = 1. It is not working. 'If strLoginAmount = "" Then strLoginAmount = 1 'Else 'strLoginAmount = strLoginAmount + 1 'End If I just want it to = 1 if it is emply Else will be incemented. What is the proper syntax? Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
