= TableAlias.FieldNamein the label caption and simply by using
= (ALLTRIM(TableAlias.FieldName))
it works fine. Even though the data in the table is already trimmed. Ok, I don't understand the why of it, but either way thanks!PUBLIC oform1 > >oform1=NEWOBJECT("form1") >oform1.Show >RETURN > >* >DEFINE CLASS form1 AS form > > > Top = 0 > Left = 0 > Height = 285 > Width = 482 > DoCreate = .T. > Caption = "Form1" > MaxHeight = 1024 > Name = "Form1" > > ADD OBJECT label1 AS label WITH ; > FontUnderline = .T., ; > Caption = (ALLTRIM(Products.eng_name)), ; > Height = 17, ; > Left = 97, ; > Top = 36, ; > Width = 288, ; > ForeColor = RGB(0,0,255), ; > Name = "Label1" > > ADD OBJECT command1 AS commandbutton WITH ; > Top = 173, ; > Left = 307, ; > Height = 27, ; > Width = 84, ; > Caption = "Next", ; > Name = "Command1" > > ADD OBJECT command2 AS commandbutton WITH ; > Top = 173, ; > Left = 91, ; > Height = 27, ; > Width = 84, ; > Caption = "Prev", ; > Name = "Command2" > > PROCEDURE Load > CLOSE DATA > OPEN DATABASE (HOME(2) + "\data\testdata") > USE Products > ENDPROC > PROCEDURE command1.Click > SKIP IN Products > Thisform.label1.Caption = ALLTRIM(Products.eng_name) > ENDPROC > PROCEDURE command2.Click > SKIP -1 IN Products > Thisform.label1.Caption = ALLTRIM(Products.eng_name) > ENDPROC >ENDDEFINE >>