Hi JPD and Alex,

thanx for your kind help the last time. now i need it once more.

i use an MSaccess created text database for dbman. here is a sample record:

B005C|Restaurant / Bar|Restaurant/Bar| |1/23/99|Business|0|1|0|0|0|0|1|Furnished and includes staff rooms.| |Three year renewable contract.| || ||0|0|Koh Samui|Chaweng|b005c| || |thaisite

the seven 0 and 1 fields represent checkboxes in access. unfortunately they wont be displayed as checked in dbman. i use the following code in cfg

CatLand => [6, 'alpha', 0, 23, 0, '', ''
CatBusiness => [7, 'alpha', 0, 23, 0, '', ''],
CatHotel => [8, 'alpha', 0, 23, 0, '', ''],
CatEnter => [9, 'alpha', 0, 23, 0, '', ''],
CatShop => [10, 'alpha', 0, 23, 0, '', ''],
CatAppartement => [11, 'alpha', 0, 23, 0, '', ''],
CatHouse => [12, 'alpha', 0, 23, 0, '', ''],

and


# Checkbox fields. Field name => Checkbox value.
%db_checkbox_fields = (
CatLand => 'CatLand',
CatBusiness => 'CatBusiness',
CatHotel => 'CatHotel',
CatEnter => 'CatEnter',
CatShop => 'CatShop',
CatAppartement => 'CatAppartement',
CatHouse => 'CatHouse' );


please advise me again.
thanx a lot
dirk

What I would do is import the database file back into Access. You'll need to change the filetype for those fields to "text" and then run a series of update queries to change the 1's to the text you want them to be for each field. Shouldn't take but a few minutes to do it.



------------------
JPD