Show subitem on form

[Thingol]

Hi everybody,

I'm trying to create a cash registry database. I have made a list of ledgers and a list of subsidiary ledgers, e.g. a ledger for household costs, for transportation, for sports, for salary, etc. and subsidiary ledgers for say food, personal care, petrol, Car maintenance, etc.

That should serve as a background, now to define my problem:
I want to create a form that looks somewhat like this (the ledger-numbers are just examples):

Income
900 Salary
910 Other income

Costs
800 Household costs
8001 Food
8002 Personal care
810 Transportation
8101 Petrol
8102 Car maintenance

As you can see, each ledger and subsidiary ledger has a number and a name. They also have a type, that defines if they belong on the income or on the costs side. I have a table defining the ledgers along with their names, numbers and types. The numbers ar used as primary keys. For the subsidiary ledgers, the table also contains a field indicating to which ledger it belongs.

Now, it is quite easy to create the form showing all the ledgers and subsidiary ledgers using some queries and subforms, but I have a hard time making the subsidiary ledgers stand out (in this example I used indentations, but I might also make the font of the subsidiary ledgers smaller or something. I hope someone could give a hint on how to make a form work like the one above.

Best regards,
Martijn Senden.

In the Beginning there was nothing, which exploded.

--Terry Pratchett, Lords and Ladies--

 

[Trevil]

You can use 'Conditional Formatting' on the text box to test for values, then set font options, however this will not indent.

You could change the SQL that selects the records to test the values and then add a few spaces in front of your text. However, this can lead to problems if you are going to edit the values you just altered.

"Hmmm, it worked when I tested it....