Wrox Programmer Forums Search Results
 | Search | Today's Posts | Mark Forums Read
 Welcome to the p2p.wrox.com Forums. You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 Showing results 1 to 4 of 4 Search took 0.00 seconds. Search: Posts Made By: mmcdonal
 Forum: Access October 2nd, 2006, 11:21 AM Replies: 7 Views: 1,663 Posted By mmcdonal Actually, you might have to do this: If... Actually, you might have to do this: If Right(sCustID, Len(iCustID)) = CStr(iCustID) Then ... End If Or Dim sCustID As String Dim iCustID As Integer
 Forum: Access October 2nd, 2006, 11:19 AM Replies: 7 Views: 1,663 Posted By mmcdonal Also, what I was saying before, is accept the... Also, what I was saying before, is accept the number value without the leading zeroes, then display it with them, as Mike suggests. mmcdonal
 Forum: Access October 2nd, 2006, 11:18 AM Replies: 7 Views: 1,663 Posted By mmcdonal Code this, then: Where sCustID = the string... Code this, then: Where sCustID = the string value "0001234" and iCustID = the number value 1234 If Right(sCustID, Len(iCustID)) = iCustID Then ... End If This will compare the two values...
 Forum: Access October 2nd, 2006, 07:46 AM Replies: 7 Views: 1,663 Posted By mmcdonal I don't think there is a way to do this. Why do... I don't think there is a way to do this. Why do you need to maintain the 0? If the 0 needs to be there, then this probably isn't really a number data type. Only use a number data type when you...
 Showing results 1 to 4 of 4