subform and listbox to appear the same to an end user

I have been using list boxes in preference to continuos subforms to good effect

however, on certain columns where there is a numeric value, i would like the column date to align right

as i understand i cannot format the alignment of individual columns in a list box, i will then have to use a continuous form instead

thats okay, but i would like the user interface for both listboxs and continuous subform to be the same for the end user

does anybody have any ideas on how to have the continuous subform acting the same as a listbox, in so far as

the mouse pointer staying a pointer rather than a cursor over the rows in a continuous subform

on clicking anywhere on a CS row the event is actioned

thank you

You could use the «Details_Click()» method with the textboxes «Enabled» property at «NO».

Thanks for your reply

i set the textbox enabled proprty's to no and the details as the event action,
but when the form opens, in the continuous subform, only the first record is active, how do i open up another record from another row apart from the first, if i am not using record navigation

Just add an «AddNewRecord» button in the footer, which opens another form in which you enter the datas.

Hi I appreciate your time, but i think it may the track may be confused

let me clarify

i have 2 forms, one which has a list box with 4 columns of data and say 20 rows

i have another form, with a subform continuous in property again with 20 records

either way i dont want to delete or any records, i just want to see the list in order to choose and edit

clicking on either a row in the listbox or a row in the subquery opens up a record to be edited

but the problem i face is, i want the user interface for the end user to be the same when using a form with a listbox or a form with a continous subform (as the end user wont know the design anyway)

the differences i have to overcome on using the continuous subform are

the mouse pointer staying a pointer rather than a cursor over the rows in a continuous subform

on clicking any row along anywhere on a continuous subform record, the event is actioned