Whitespace

Comments

• Anu de Deus Hampshire, UK

  September 2010 edited 11:06PM

  In your memoview.text, where you have something like '[<dataset.field1>]', merge the contents of your memoview objects in one:
  'Dear [<dataset.field1>] and [<dataset.field2>]'
• bdmiller

  September 2010 edited September 2010

  Thanks for the prompt reply
  
  Sorry tried that but still not working
  I have combined the two fields as expression
  

  [<Customer."First_Name">+<Customer."Last_Name">]
  

  
  The whitespace allways appears. Can i set field widths dynamically from code as in sql, see code below
  

  SELECT RTRIM(First_Name),RTRIM(Last_Name) FROM Client_Record WHERE Client_No = :Client_No
  

  
  I can then add
  

  form2.ClientLabel.Caption.Text:=FirstName+''+LastName;
  

  
  No whitespace
  
• gordk St.Catherines On. Canada.

  September 2010 edited 11:06PM

  
  Anu was correct, it is the fact that your white space is coming from your data that you need to wrap the fields with appropriate functions.
  first when using multiple fields in 1 memoview don't link the memoview to a data set or field
  just use an expression.
  The expression may be built using the expression builder
  ie select memoview rclick and enter edit mode
  select the expression button and the expression builder dialog appears
  select the desired function in the expression box place the cursor between the ()
  then go back and select the datafield click on okand the correct text will be added to the memo.
  ie
  [Trim(<Customer."Firstname">)] [Trim(<Customer."LastName">)]
• bdmiller

  September 2010 edited 11:06PM

  Thanks for the prompt reply from you guys, worked a treat.
  
  I had been trying to use Trim, but in the wrong place.
  
  Thanks, best service ever.