Recent content by lana

I did it. #,##0;[Red](#,##0) in filed format. Thanks

Thanks for the reply. This changes the negative to positive. But I need the value to stay negative but only appears positive in the datasheet. I have seen this in other programmes. When the number is selected it shows the negative value. I think it's done with conditional formatting, but don't...

Hi there, Is there a way with conditional formatting to change negative numbers to appear positive in a datasheet? Thanks a lot

God bless you. Thanks so much.

Hi there, I have a form with a subform. The recordsource of the subform is a table. When the user changes the sort order of one of the fields in the subform, this sort order stays until the form is closed. I need to change this sort order by VBA. Any ideas? Thanks a lot

Thank you all. control-name.text worked like a charm. Many thanks again.

It does not work. When the date is entered incorrectly, the _onError event fires, the _BeforeUpdate event does not fire. When I look at the field value in the OnError event, it's null, or the old value, not the incorrect entry. Thanks again for your time.

I need to show my own messages, If possible! Before the beforeUpdate event fires, the error message appears. I trap the error in the OnError event but the value of the text box is still the old one because it is not updated. Thanks

Hi there, I need to trap the date field entry errors on my forms. The date format is mm/dd/yyyy If it is entered as 08/20/2021, everything is OK, but if it is changed to 13/20/2021, I could not trap the error because the field value is still the old one (08/20/21). I need to trap the error and...

I meant the MVF is nonsense. Your article helps a lot of people like me. Cheers

Yes I did. I agree with you completely. it's nonsense. Thanks

Thanks again.

Thank you for the replies. I tried the .value part but it shows the IDs, not the names like (David,Smith,Lara). Is it possible to show the multi-selected data as it appears in the query (David,Smith,Lara), on a form or I am wasting my time? Thanks again.

Hi there, Can anyone help me regarding the multi-value field? I have a multi-value field and the selection is OK. Now I need to show the data stored in that field in a text box or a sub-form. Example: stored data is "David,Smith,Lara" I can see it in the table or in a query but I can not use...

Thanks. The shortcut does not work because the program starts with .exe file. Thank you.