Hopefully someone has seen this and has a solution - A user of a multi-user
application (2003) I developed recently reported that when typing text into certain fields
fields (bound to memos) on a form, that the text displayed backwards or reversed. This
occurred on his PC while a user next to...
I've been able duplicate your problem by specifying a format (@) in the field property Format in the query grid. Could you be applying any formatting to your memo field in the query itself?
I've done it by referring to a hidden bound object frame on a form:
Forms!YourForm!YourObject.Verb = acOLEVerbOpen
Forms!YourForm!YourObject.Action = acOLEActivate
That was the reason why I attached it to the Save button (it was an automatic Undo until all the fields were filled in).....Glad you found a work around
Rick
Try something like:
SELECT YourTableName.Field1, YourTableName.[Field2], YourTableName.Field3, [Field1] & [Field2] & [Field3] AS SearchCriteria
FROM YourTableName
WHERE ((([Field1] & [Field2] & [Field3]) Like "*" & [Enter Word to Search For] & "*"));
Hope this helps
Rick
My mistake.....I originally attached the validation code to a Save button (it always reset validated fields), but if you're going straight to the close button, you may want to make reference to a save routine in the close button's On Click event ( or the On Close event)
I don't beleive that you can change the backcolor of a checkbox but here's a possible work around:
Create a textbox named txtChecked, size it, set the font size to whatever size you want), set Enabled and Locked properties to Yes, and add this code to the On Click event:
If...
This may help:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;210271
just remove the portion that closes Word:
'Quit Microsoft Word and release the object variable.
objWord.Quit
Set objWord = Nothing
If you go with the text field (assuming your combobox fields are set up like Noun, Description), you could, in the AfterUpdate event of the combobox use:
Me!YourTextBox = Forms!YourForm!YourComboxName.Column(1)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.