Arrows on textbox remove

I have various textboxes on my form. However when you point to a specific textbox some arrow type buttons appear on the right side of the textbox impeding on the actual textbox space. I do not want these there, is there a way to remove them?

Sponsored Links:

Related Topics

Unwanted Lookups automatically added to Forms
I'm a beginner in Access and just completed a 3 day class. Was doing fine until a few days ago. I created a table in a new database, and put in a lookup in one of the fields of the table. Realizing that I should have done this in the corresponding form instead, I tried to delete it.

When I created the form, the control for that table field had the up/down lookup arrows on the control, even though there was no list to look up.

Could not delete it. I started over with a new database and got the same results.
Now - every single form I try to create, either in existing databases or new ones, has the lookup arrows on every control of a text field. I am not adding lookups to the tables or the forms.The forms have no lists of data to look up, just the arrows.

How do I get rid of this? I have done several dozen tests and keep getting the same results.


confused with append method
here it goes,

I have tabcontrol with 3 page in it. every page consists of 5 text boxes
4 boxes are set visible to false, not until the first box meet the certain criteria and the second box will be visible, when the 2nd box meet the 2nd criteria the box will be visible as well and so on.
the second and third page are the same with page 1. they have 5 boxes each tabpage and same condition as page1.

now, my question is.

how can I append the records in a table in just 1 field without blanks.

let say, on page 1
textbox 1 = 10
textbox 2 = 15
textbox 3 = 20
textbox 4 not visible
textbox 5 not visible
on page 2
textbox 1 = 5
textbox 2 = 18
textbox 3 not visible
textbox 4 not visible
textbox 5 not visible
on page 3
textbox 1 = 3
textbox 2 not visible
textbox 3 not visible
textbox 4 not visible
textbox 5 not visible

the table will appears like this

Table sample


How to update textbox using combobox
my question is, what can I do so that when I click a command button the text shown in a textbox or combobox will be added to an other textbox preserving the old values for that textbox


TextBox Content
I have made an application with some textbox. I found that when I click on a textbox, its content and texts are moved to right. It seems there is one space at the begin of the textbox.


How to solve "Unbound Textbox"
I have a basic database, contains:
1. ID
2. Name
I want to have a textbox for user enter amount of money and then click a button. Then a report appear (must have a textbox value in form Input - do not tell me add this textbox like a filed in DB).
I try 1 day but it did'nt work.


SET focus back to TEXTBOX if validation does NOT pass
I have a textbox with a validation in the "lost focus" property. if the text the user inputs in the textbox is incorrect, it clears out the textbox. but, for some reason after the validation message box appears for the user, the cursor moves to the next textbox.

how do I get the cursor to go back to the original textbox with the validation?

basically, until the user enters a correct string, the cursor will not move to the next textbox.


SET focus back to TEXTBOX if validation does NOT pass
I have a textbox with a validation in the "lost focus" property. if the text the user inputs in the textbox is incorrect, it clears out the textbox. but, for some reason after the validation message box appears for the user, the cursor moves to the next textbox. how do I get the cursor to go back to the original textbox with the validation? Basically, until the user enters a correct string, the cursor will not move to the next textbox


Enable checkbox when locked textbox changes
I have a form that has a locked textbox and other textboxes (not locked) and some checkboxes. I would like to enable two of the checkboxes when the data on the textbox changes. I added a not visible textbox with the control source of the locked textbox and used it's afterupdate event, but this does not fire as I tab through the records. What do I need to do to make thiswork?


Form next record advance arrows
Does any one have the vba code that refers to the arrows at the bottom of a form to advance records. I can make buttons to do it, but I want to make my form idiot proof. If so I would also like the code for the last record and the first record buttons


AfterUpdate Not Firing
I have a subform which has a textbox in the footer which calculates a total amount. On my main form I have a textbox with the control source set to the textbox on my subform.

What I want to do, is every time this textbox changes, to update another textbox with the same amount. So Textboxtotal and TextboxCopy are the same all the time.

I understand that the afterupdate event wont fire as it is not updates via keypress, but I'm stuck there.


sorting data in a textbox control
To sort data in a txt box. I am using this textbox on a report and have concatenated group totals in the textbox.

I need to find the Median of the list and in order to do this, the list, in the textbox needs to be sorted.


data from one form to another form..
I have 2 tables in microsoft access with corresponding forms (table1:form1) & (table2:form2). in form1 I have 3 fields: result(dropdown) & name(textbox)&address(textbox).in form2 I have 2 fields: name(textbox)& address(textbox).

what I want is when I choose the "POSITIVE" in the form1 result(dropdown),the name(textbox)and address(textbox) I entered are copied to name(textbox) & address(textbox) inform2 and this will happen as I exit the form1 or if ill make a new record.


sum in form footer
I have this problem and I cant figure it out how many times I have tried it myself.

I have this subform, and it has 4 textbox: three that is bound and the one that is unbound form.

when I do calculations in the bound textbox, I can successfully arrive at the sum of textbox3 but when I sum the fourth unbound textbox, it give an error inside the textbox.

Does it mean I cannot make a summation of an UNBOUND textbox


Selecting and Moving Objects Slow in REPORTS Design View
In DESIGN VIEW for REPORTS, when I select and/or move objects (text boxes, etc.) there is a delay of up to 10-15 seconds before the object "gets focus" and/or actually moves. Sometimes I use the keyboard direction arrows to move the objects - there is the same delay - after 10 seconds the object will move the number of times that I've pressed the down/up arrows. This does not happen when I move objects in FORMS


Change text in the textbox to propercase
I have a textbox that stores customer name so when the user starts typing the text in that textbox then it should convert into vbpropercase that means first letter capital and then rest of the letters small.:
If I use the following code on change event of the textbox then it doesn't work and Infact the textbox doesn't allow me to input anything:

textbox1=strconv(textbox1,vbpropercase


TextBox calculation
I have a Form with textboxes,combobox and a button to calculate the discount level (comboBox) discount total (textbox), tax total (textbox) and total all these up into the total order(textbox) this is working except the discount total textbox...


Possible to mouse over a bound textbox to show all info in the box?
Does access have a mouse over feature like in excel where theres a red carrot and if you roll over it, a note appears?

I have a form with a bound textbox. this textbox contains notes. however due to the size of the form, the textbox does not show all of the notes sometimes and user has to click the textbox and scroll to the right to read it.

Is there a way the user can mouse over the textbox and another box appears with the full notes in it? if not, is there something similar?


Cannot add records to the data base
So my problem is this. I have a main form with a subform in it. When I set them threw options to dynaset I can add new records to the data base but I can not navigate threw the arrows to the previous records.
When I set the properties of the form to snapshot ,then I can navigate to the records threw the arrows of the form but I can not add a new record.
I know about the language barrier since the data base is in greek so the steps
are :
1.Click the first choise.
2.This is the form. Now you can experience the same situation!

I am not an expert and this is my 5 database I make


Linking Text Boxes in MS Access
How do I link a textbox in a report to a textbox in a form so that the textbox in the report displayes the exact same value as the textbox in the form, as I want to send this report as an email because I can't do this in a form.


Conditional Format Textbox
I am a very basic user of Microsoft Access with no formal training. I had to build a database for work originally in Excel, but it took too much time when updating it on a weekly basis. SoI switched to Access and cut my work on this database by two-thirds each week.

I need to have Textbox 71 of my reports highlight in red when the following two conditions are meet:
1. Textbox 67 = "M"
2. Textbox 71 > "13:00"

I have used Conditional Format for Textbox 71 to highlight another condition when the value in the Textbox 71 is greater than "14:30" for all values.

I am guessing I need to write some sort of formula...