Hi, I have a Split form. Works fine.
I want a few columns in the datasheet part to not be visible but visible in the Form part. Is it possible?
Please advise how?
Hi, I have a Split form. Works fine.
I want a few columns in the datasheet part to not be visible but visible in the Form part. Is it possible?
Please advise how?
Is the datasheet based on a query? If so, remove the column from the query. You can also hide fields in a datasheet view, and they can be unhidden later, but it sounds like you don't want them at all.
Could not remove from query if you want visible in form part. Column can be hidden in datasheet part with Right Click > Hide Fields - position cursor over column head in datasheet.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks June7. Simple and thats what i needed. The problem was we cannot do this in Design mode as only the Form part is displayed in Design mode.