alignment=0...3 
 | 
  
 | 
x 
 | 
Alignment 0 - (Default) Left, 1 Right, 2 Center, 3 Justified 
 | 
autohscroll=1/0 
 | 
  
 | 
x 
 | 
set horizontalscroll in column items 
item.mycolumn.autohscroll=1 
 | 
autovscroll=1/0 
 | 
  
 | 
x 
 | 
set verticalscroll in column items 
item.mycolumn.autovscroll=1 
 | 
background.<type>=<color> 
 | 
  
 | 
x 
 | 
  
With the following commands you can define background colors for different statuses. 
it's only working for columns, not other item types 
  
background.ok 
 | 
Color if all ok  
dw_1.item.mycolumn.background.ok=<color:backgroundcolor_ok> 
dw_1.item.mycolumn.redraw 
 | 
 
background.error 
 | 
Color if error (field-Status=error) 
dw_1.item.mycolumn.background.error=<color:backgroundcolor_error> 
.. 
dw_1.item.mycolumn.status=error 
redrawallcolumns 
 | 
 
background.empty 
 | 
color if field is empty of field-Status=empty 
Example: OpenEvent. OK=green, Empty=read Background 
dw_1.item.itemcode.background.ok=<color:backgroundcolor_ok> 
 | 
 
 
 
  
with property status you can change the status of the field and related to this the background 
dw_1.item.mycolumn.status=error 
dw_1.item.mycolumn.redraw 
  
or with setstatus you can change the status and can redraw the column automatically 
dw_1.item.mycolumn.setstatus=error 
  
if you change many properties outside load event, you can start the redraw for all columns with this command. 
redrawallcolumns 
for redraw all fields 
  
 | 
 
 
 
 | 
bitmapname=bmp\<bitmapname> 
 | 
  
 | 
x 
 | 
Name of bitmapfile  
(bmp, jpg, gif, png) 
 | 
bold=true/false 
 | 
  
 | 
x 
 | 
  
Example: 
dw_1.item.mycolumn.bold=true 
  
if you set this outside the retrieve / load mode, you must set the command. 
redrawallcolumns 
to redraw all fields 
 | 
 
 
 
 | 
color 
 | 
x 
 | 
x 
 | 
  
Example: Red 
dw_1.item.mycolumn.color=<rgb:255:0:0>  
  
you can send a formula, too 
  
dw_1.item.mycolumn.color='255~tif (left(ag_id,1)="A",255,0)' 
  
or better with the modify command 
  
dw_1.modify.mycolumn.color='255~tif (left(mysecondfield,1)="A",255,0)' 
  
if you set this outside the retrieve / load mode, you must set the command 
redrawallcolumns 
for redraw all fields 
 | 
 
 
 
 | 
coltype 
 | 
x 
 | 
  
 | 
  
 | 
dbcolumnname 
 | 
x 
 | 
  
 | 
Return the column name 
 | 
dbname 
 | 
x 
 | 
  
 | 
  
messagebox=<item.mycolumn.dbname> 
 | 
 
 
 
 | 
dbtablename 
 | 
x 
 | 
  
 | 
  
messagebox=<item.mycolumn.dbtable> 
 | 
 
 
 
 | 
detailbitmap 
 | 
  
 | 
x 
 | 
 | 
destroy 
 | 
  
 | 
x 
 | 
 | 
displayonly=1/0 
 | 
  
 | 
x 
 | 
Only Column: set input-field to only view 
 | 
dropdown 
 | 
  
 | 
x 
 | 
Create dropodwn window or open it 
 | 
expression=<expressionvalue> 
 | 
  
 | 
x 
 | 
set expression (formel) (only computeobject) 
 | 
escapement 
 | 
  
 | 
x 
 | 
  
Rotation on a field in 1/10° (0 - 3600) 
  
Example: rotate the field "itemcode" 3 times 
  
for ll_1=1 to 3 
  for ll_2=1 to 3650 step 100 
    dw_1.item.itemcode.escapement=<ll_2> 
   next 
next 
 | 
 
 
 
 | 
format=<format string> 
 | 
  
 | 
x 
 | 
Displayformat. Only Column and Compute Example: #,##0.00  = 3,000.34 
 | 
formatstring 
 | 
  
 | 
x 
 | 
Properties: 
background.ok (or bok) 
background.error (or berr) 
background.empty (or bemp) 
status 
bold 
italic 
color 
text (Only Textfield or the Textfield "columnname+"_t" from column, replace comma to "&|") 
  
Example: 
item.mycolumn=formatstring=bok=<rgb:100:255:100>,berr=<rgb:255:100:100>,bold=true,italic=true,text=My Field Description 
  
If you set design-Properties as bold, italic e.c. and your Script is not in open- or itemchange-event, you must make a redraw . 
item.mycolumn.redraw 
 | 
 
 
 
 | 
hscrollbar=1/0 
 | 
  
 | 
x 
 | 
  
is displayed in the control when all the data cannot be displayed at one time. Values are: 
1 – Horizontal scroll bar is displayed. 
0 – Horizontal scroll bar is not displayed. 
 | 
 
 
 
 | 
italic=true=false 
 | 
  
 | 
x 
 | 
  
Italic on/off 
dw_1.item.mycolumn.italic=true 
  
if you set this outside the retrieve / load mode, you must set the command 
redrawallcolumns 
for redraw all fields 
 | 
 
 
 
 | 
mandatory=true/false 
 | 
  
 | 
x 
 | 
  
with this command you can set the field as mandatory field. 
if it's empty, you can't update the data 
  
 | 
 
 
 
 | 
password=1/0 
 | 
  
 | 
x 
 | 
Only Column: set to password-field. You can see only "***" 
 | 
protect=1/0 
 | 
  
 | 
x 
 | 
Activates and deactivates editing of a field 
 | 
redraw 
 | 
  
 | 
x 
 | 
  
if you change design properties, example bold, italic, color, background color outside the load / retrieve events, you must redraw the properties 
  
item.mycolumn.redraw 
  
or for all commands 
  
redrawallcolumns 
 | 
 
 
 
 | 
rightclicktrigger 
 | 
x 
 | 
x 
 | 
Define function of right-click 
  
 | 
setfocus=<column> 
 | 
  
 | 
x 
 | 
  
dw_1.item.mycolumn.setfocus 
 | 
 
 
 
 | 
tabsequence=<x> 
 | 
  
 | 
x 
 | 
  
(only Columns): A number from 0 to 32000 specifying the position of the column in the tab order. A value of 0 takes the column out of the tab order and makes it read-only. 
item.mycolumn.tabsequence=20 
 | 
 
 
 
 | 
tag 
 | 
  
 | 
x 
 | 
  
Beas uses this to define click commands. 
You can get the actual value 
  
messagebox=<item.mycolumn.tag> 
 | 
 
 
 
 | 
text=<textvalue> 
 | 
  
 | 
x 
 | 
Only Text-Fields: set the Text to display 
 | 
title=<textvalue> 
 | 
  
 | 
x 
 | 
  
dw_1.item.itemcode.title=The Item Code 
  
 | 
 
 
 
 | 
type 
 | 
x 
 | 
  
 | 
  
return the type of column: column, text, bitmap, compute 
 | 
 
 
 
 | 
simulatetype 
 | 
  
 | 
x 
 | 
  
define a "simulation" type for columns type char 
use this example for udf or userfield 
  
item.udf5.simulatetype=date 
  
convert every manual entry to date format 
  
item.udf5.simulatetype=#0.00 
  
convert every manual entry to decimal format with 2 decimal places 
String to Number is always working, if # is inside the format 
beas 9.3 PL 2 
 | 
 
 
 
 | 
visible=1/0 
 | 
x 
 | 
x 
 | 
set visible true/false 
 | 
status 
 | 
  
 | 
x 
 | 
change status between OK, error or empty 
redraw background color, front color and some other properties, which you can define with formatstring 
if you change it outside open/new event, you must send an redraw 
dw_1.item.itemcode.status=error 
dw_1.item.itemcode.redraw 
 | 
 
 
 
 | 
setstatus 
 | 
  
 | 
x 
 | 
change status between ok, error or empty 
redraw background color, front color and some other properties, which you can define with formatstring 
Same as command "status", but it redraw the column automatically Beas 2020.02 
dw_1.item.itemcode.setstatus=error 
 | 
 
 
 
 | 
vsrollbar=1/0 
 | 
  
 | 
x 
 | 
  
displays in the control when not all the data can be displayed at one time. Values are: 
1 – Vertical scroll bar is displayed. 
0 – Vertical scroll bar is not displayed. 
 | 
 
 
 
 | 
x,y,width,height 
 | 
x 
 | 
x 
 | 
  
dw_1.item.mycolumn.x=200 
setvar=ll_y=<dw_1.item.mycolumn.y> 
  
 | 
 
 
 
 |