trim function (resolved)

**Goh** · Jun 30th, 2005, 12:56 AM

does anyone knows what Trim(!Deleted & "") means ? what is this Deleted and ! and so on ..i only knows Trim(string)

thanks

**lintz** · Jun 30th, 2005, 01:08 AM

It seems you (or whoever's code it is ) has opened a recordest and is triming the field called Delete.

eg..

VB Code:

'open Recordset 
 
With myRecordset
 
MyValue = Trim(!Delete)
 
End With

**Goh** · Jun 30th, 2005, 01:13 AM

and what about &"" ?

the actual coding is flex1.TextMatrix(flex1.Rows - 1, 0) = Trim(!Deleted & "")

and why is there an ! ?

**mendhak** · Jun 30th, 2005, 01:16 AM

Why is this in the ASP.NET forum as well?

**Goh** · Jun 30th, 2005, 01:20 AM

oppos sorrie i post it wrong accidentally

**Frans C** · Jun 30th, 2005, 01:50 AM

The & "" part is to prevent an error when the value in the database is null.
Because Null & "" = "" no invalid use of null error is thrown.

**Goh** · Jun 30th, 2005, 02:29 AM

i see thanks

Thread: trim function (resolved)