Microsoft Access / VBA Forums on Bytes. Private Sub TextBox_CB_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Application.ScreenUpdating = False 'TRANSFORMER LE POINT PAR UNE VIRGULE If KeyAscii = 46 Then KeyAscii = 44 'ACCEPTER UNIQUEMENT UNE SEULE VIRGULE ET LES CHIFFRES ENTRE 0 ET 9 If InStr("1234567890,-", Chr(KeyAscii)) = 0 Or Me.TextBox_CB.SelStart > 0 And Chr(KeyAscii) = "-" _ Or InStr… Remove multiple Chr(13) & Chr(10). It can be used as a VBA function (VBA) in Excel. I use Access to export an excel file formatted, full of data, with VBA Attached. James A. 通常改行するには、上の2つを合わせて「Chr(13) & Chr(10)」のようになりますが、これは「vbCrLf」と同じことです。空白で姓と名が分かれている名前を、上の3種類を使い改行してみます。空白で分かれている名前から姓だけ取り出す As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor. The Microsoft Excel CHR function returns the character based on the ASCII value. Fortune . ji*****@compumarc.com wrote: lauren quantrell wrote: Has anyone cunstructed a function to remove …

When I open the excel I notice that a lot of my longer cells (easily over 255 characters) have line breaks, but my routine for removing the access-necessary, excel-unnecessary chr(13) only works … The CHR function is a built-in function in Excel that is categorized as a String/Text Function. By ... Do While InStr(mytext, Chr(13) & Chr(10) & Chr(13) & Chr(10)) > 0 mytext = YourFunction(mytext) Loop Post back if you need something better. Nov 13 '05 #2. VBA not replacing CHR(13), still displays a bunch of white boxes Hello, MS ACCESS/EXCEL 2003 on XP PRO.

P: n/a Trevor Best.