asked on

hiding columns in continuous form tabular layout

hi all, previously Christian and gustav was helping me out with a question and Christian made a comment

if you hide a column in Datasheet view in a normal continous form and not in a form view with Layout assigned then there should be no problem with gridlines, like Gustav said above (ColumnHidden property).

Christian / anyone, could you show me specifically for my "GenericForm":
1) how i can hide my columns programmatically?
2) also if i were to do it manually how do i hide the column?
3) i think my case falls under Christian's layout assigned case - is this true?
DMS-Cerebro---SSB-Recon.mdb

pdebaets

1. From Access help:

The following example hides the ProductID field in Datasheet view of the Products form.

Forms!Products!ProductID.ColumnHidden = -1

2. Right-click on the column, select "Hide Columns".

3. I don't know what you are talking about.

ASKER CERTIFIED SOLUTION

Bitsqueezer

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

developingprogrammer

ASKER

super cool Christian, let me go through this and get back to you = )

developingprogrammer

ASKER

hi Christian, i'm so sorry about getting back to you so late on this especially when you've helped me to modify my code = ((

i think the main reason why i stay away from the form header buttons and sub form details sheet is because i want the user to feel they're clicking on the button relevant to the row cause the button is physically on the row itself.

hrmm thanks for correcting my methods in implementing this Christian, i will need to have a think about this and reattempt a generic form after my project is done so i can do it with the proper knowledge. thanks once again and i'm so so sorry for the delay!! = ((

Bitsqueezer

Hi,
no problem, I'm not in hurry...:-))

Cheers,

Christian

developingprogrammer

ASKER

Thanks for being SOOOO understand, helpful and patient all this while Christian!! = ))