How do you do Read-Only?

[Morpheus_UK]

Hey all,

How do you do read-only for a subform on a form? Can u do this, I don't know how to make forms alone, read only, I've swear I saw read-only forms before.

Basically I'm trying to make the textbox on the subform appear as a label to go ontop of a header strip I made. The textbox's source is based from a query made to produce a persons Full Name

[Forename] & " " & [Surname]. It works, my issue here is how it looks. Plus the fact u can click in a textbox and change the data, I don't want this (I have a separte form for entering/editing Name details i.e. Title, First Name, Middle Names etc).

Thanks in advance,

 

[Pat Hartman]

You can use the Enabled property of a control to "grey" it out and prevent the cursor from entering the field. Or, you can use the Locked property and TabStop property to do the same thing without "greying" the control.

To make a subform read-only, set all the "allow" properties on the data tab to No.

 

[Morpheus_UK]

Cheers Pat. Thank You for your help with the tbl structure for the Membership questions in the general section. This is also my first database, so may be asking bits as I get stuck.

Back to the thread I set the Locked property to 'No' and it done the trick. Do I need worry about the TabStop property, I can't find it?

 

[Pat Hartman]

It is on the "Other" tab. Locking the field prevents it from being changed but it doesn't prevent the user from tabbing into the field. If you don't want the user to be able to place the cursor in the field at all, set the TabStop property to No.

 

[Morpheus_UK]

problem here at top, got another pic. Sorry don't have a program to zip a folder.

 

[Morpheus_UK]

Ignore the previous post by me, think I've got it, post back in a min what problem I had

 

[Morpheus_UK]

What happened was on a Blank form the detail section on subform showed up as black instead of displaying the picture I inserted as showed in the pic I attached a couple of threads back. I delete the picture (gradient fill) and found in the properties of the form (subform on the JPG) an option for embeding a picture, resized the form, repositioned the subform on my form that contaned it and it looks seemless. Thanks for guidence Pat.

The JPG attached here shows what I was after. The top bit shows the top of a Blank Form, Just below that is a filled in form (slightly).

When I select a record from the List Box on the right, the Full Name of that person appears in the header (not form header) at the top, unchangeable from the textbox. I know its not alot to get happy about but, I'm trying to make it easy to read Peoples profiles, like all lbeginners, your happy you got summit to work, however small.


P.S. Aint got round to the filters of the list on the right yet, want to search by category through all names, then from that list of names, it can be shortened again by selecting a range of letters the surname begins with, e.g. Selecting I-J from the screenshot I attached cums up with the 2 Killick names, riding of the Sandle Name as an option.